Just realised you wanted both ... sorry I don't know On Sat, Jan 17, 2009 at 11:57 PM, Sid Bachtiar <[email protected]> wrote: > "UPDATE a=1, b=2, c=3 FROM table WHERE yada yada LIMIT 1" > > On Sat, Jan 17, 2009 at 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 >> >> >> >> > > > > -- > Blue Horn Ltd - System Development > http://bluehorn.co.nz >
-- Blue Horn Ltd - System Development http://bluehorn.co.nz --~--~---------~--~----~------------~-------~--~----~ NZ PHP Users Group: http://groups.google.com/group/nzphpug To post, send email to [email protected] To unsubscribe, send email to [email protected] -~----------~----~----~----~------~----~------~--~---
