updating mysql table...

[richie]

include ("connect.php");

$db = "payments";
$query = "UPDATE replies SET moved='$fromRen' ";
$query .= " where login='$login' ";
$result = mysql_db_query($db,$query,$connection);

$queryB = "UPDATE personalFolders SET folder='$fromRen' ";
$queryB .= " where login='$login' ";
$resultB = mysql_db_query($db,$queryB,$connection);

---

I need to update two tables at once within the same database.

My code is as shown above.

Unfortunately, only the first table gets updated.

Can somebody tell me why this is?

TIA.

[ahundiak]

I don't see a syntax error but try adding
if (mysql_errno()) die(mysql_error());
After each of the mysql_db_query() statements.

You might have the wrong table or column name.
I assume you are positive that the queryB code is being executed. There are no if/else statements in there.

[richie]

Thank you.

I found my mistake. It had to do with the WHERE clause.