[SOLVED] UPDATE and SELECT at the same time - or at least return affected ids.

[MadnessRed]

I would like to update a table and read from it in 1 go if that is possible, something like

 

$qry = mysql_query("UPDATE AND SELECT FROM `table` SET `group` = 0 WHERE `group` = '$group' ;");
$affected_members = array();
while($row = mysql_fetch_assoc($qry)){ $affected_members[] = $row['id'] ; }

 

or

 

mysql_query("UPDATE  `table` SET `group` = 0 WHERE `group` = '$group' ;");
$affacted_members = mysql_affected_ids();

 

Is there a way to do this, or will I need 2 queries?

[tommyda]

Na you would need 2 queries as far as I know.

[MadnessRed]

ok, thanks anyway