[PHP] Select then update

Hi all! Just wondering, If I have a query like: $query = "SELECT name FROM users"; $ret = mysql_query($query); while(list($name) = mysql_fetch_row($ret)) or die("Error: ".mysql_error()); print ("your name is $name); $query_update ["name"] = ("UPDATE my_other_table set name = $name"); $result =

Re: [PHP] Select then update

You need to put {} in the while function like this while { do this } $query = "SELECT name FROM users"; $ret = mysql_query($query); while(list($name) = mysql_fetch_row($ret)) or die("Error: ".mysql_error()) { print ("your name is $name); $query_update["name"] = ("UPDATE my_other_table set