1 Query combining update & select

[jaymc]

Would it be possible to turn this into one query

 

$queryupdate = "UPDATE `blte_online` SET `rtime` = '$timestamp' WHERE `usr_name` = '$User_Session' LIMIT 1";

$query='SELECT * FROM '.$prefix."_online WHERE ($timestamp-rtime)<20 ORDER BY `group` DESC, `gen` ASC, `usr_name` ASC";

$result=mysql_query($query);

 

In otherwords, can you perform UPDATE and SELECT and have it executed in one query..

[artacus]

No, but you could technically do the update in a subquery but I really don't see the point. It wouldn't speed things up any.