I want to do a SELECT and UPDATE in one statement.

Ie: I want to SELECT a single record:

$result1 = mysqli_query($link,"SELECT a,b,c FROM table WHERE yada yada LIMIT 
1")....

AND I want to UPDATE a bool field in the result that it has selected.

The table has a PRIMARY AUTO increment field called 'id'.

Thanks in anticipation.

Michael

--~--~---------~--~----~------------~-------~--~----~
NZ PHP Users Group: http://groups.google.com/group/nzphpug
To post, send email to [email protected]
To unsubscribe, send email to
[email protected]
-~----------~----~----~----~------~----~------~--~---

Reply via email to