[RESOLVED] Select and update with one query

lpa

Hello,

I am wondering if it's possible in MySQL to combine SELECT and UPDATE statements in one query?

Thanks.

$result = mysql_query( "SELECT id, file FROM random_images 
where city='$city' ORDER BY last_showed ASC limit 0, 1") or die(mysql_error());

list($lid, $file) = mysql_fetch_row($cats);

$update=mysql_query("UPDATE random_images SET last_showed='$time' 
WHERE id='$lid'") or die(mysql_error());

dagon

you can separate them with a ; (http://www.dev-explorer.com/articles/multiple-mysql-queries) and send them in one go but it really would save only nanoseconds and would have more potential problems than its worth. Kind of difficult if your expecting to get any results back :-)

lpa

Thank you very much.

bradgrafelman

Also note that since the mysql lib was deprecated in favor of the [man]mysqli[/man] library, you could instead update your code and use something like [man]mysqli_multi_query[/man].