Dave, Can you not just do a limit one in the query? Or is all the sorting happening in PHP? If php based, could you sticks the results into an array and then just use the first element of that array? Bastien On Thu Jan 08 2015 at 1:01:16 PM DealTek <dealtek@xxxxxxxxx> wrote: > 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] > >