Select and update at the same time (with selected value)?

[Kevin K]

Hey!

I am trying to select and update a row at the same time and trying to accomplish these two queries simultaneously.

select * from pool_process where any="1" and status="" order by id asc limit 1;
update pool_process set status = "RUNNING", proc_srv="$server_id" where id="$row->{id}";

id Is the auto_increment column from pool_process.

Thanks,
_Kevin