> Op 8 jan. 2015, om 19:00 heeft DealTek <dealtek@xxxxxxxxx> het volgende geschreven: > > semi newbie > > Hi all, > > 1 - I do a query for multi records - and sort a certain way > > 2 - then I need to capture/edit just the first found record in the result (no user interaction) > > > > Q: using php - How do I set a variable to the first first found record in the result and do more with this record? > > > > -- > Thanks, > Dave - DealTek > dealtek@xxxxxxxxx > [db-15] > Just do a fetch once. See the php manual for the fetch syntax for your specific DBMS. Manipulate the data, and do an update query. See the manual for your specific DBMS. That is really all there is to it Sincerely, Jasper Kips -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php