Can you run a SQL query inside PHP to update more then one table in a single query?

PHP Code:

$query = "UPDATE table1, table2 SET table1.row = \"$data\", table2.row = \"$data2\".... 


Originally Posted by Red_X_

Can you run a SQL query inside PHP to update more then one table in a single query?

PHP Code:

$query = "UPDATE table1, table2 SET table1.row = \"$data\", table2.row = \"$data2\".... 


Never mind figured it out

PHP Code:

    query = 'UPDATE T1 AS D, T2 AS T, T3 as L SET D.row= "'.$var.'", T.row= "'.$var.'", L.row= "'.$var.'" WHERE D.row_ID = "'.$id.'" AND T.row_ID = "'.$id.'" AND L.row_ID = "'.$id.'";';