mysql update

[vystral]

For some reason, my UPDATE query isn't working. I don't think I have the syntax wrong.

 

$restidquery="select restaurantid from restaurants where restaurantname='$restaurantname'";
  $restidresult=mysql_query($restidquery);
  $restidrow=@mysql_fetch_assoc($restidresult);
  $restid=$restidrow['restaurantid'];
  
  mysql_query("UPDATE users SET restaurantid='$restid' WHERE username='$username'") or die(mysql_error());

[chigley]

Use this for debugging:

 

<?php

$restidquery="select restaurantid from restaurants where restaurantname='$restaurantname'";
  $restidresult=mysql_query($restidquery) or die(mysql_error());
  $restidrow=mysql_fetch_assoc($restidresult);
  $restid=$restidrow['restaurantid'];
  
  $q = mysql_query("UPDATE users SET restaurantid='$restid' WHERE username='$username'") or die(mysql_error());

?>

 

Where are $restaurantname and $username defined?

[vystral]

from a form on a previous page. I used $_POST for both of them

[vystral]

Wow, I don't believe this. It just started working out of nowhere. Took time for server update maybe??