Sending multiple Queries at same time?

programming
1

Hey there,

I am trying to query multiple things, so I can insert them into different fields within a table. I am a PHP newbsors, and having trouble at this part.

Running one query, is not a problem. I need to do more than that though. Hopefully PHP has the power to run more than one at a time :ponder::gas:

Here is the current PHP code I have

public function runCoordFunc($params) {
	$ProdID = $params[0];
	$Tcoords = $params[1];
        $PicID = $params[2];
        $Pcoords = $params[3];
	$query2 = "UPDATE amfphp_db SET TextCoords = '$Tcoords' WHERE ProductID = '$ProdID'";
	if ($result = mysql_query($query2, $this->connection)) {
   		return true;

So this works fine but I need to run more queries. One to insert $PicID into a field, and another to insert $Pcoords into a field. Where do I go from here?

Can I just add the Queries, line by line? Maybe extend the if statement to encapsulate all the Queries?

Thanks so much if anyone knows :love: