This is not possible. My initial thought was to use a trigger, but they only get fired on insert, update or delete.
You'll probably have to keep track of the selects by manually issuing an update statement using the same conditions as the select. R On Jan 17, 11:47 pm, Michael <[email protected]> wrote: > 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] -~----------~----~----~----~------~----~------~--~---
