Re: How can I capture just the first record in a found set and edit it?
| From: | David OBrien | Date: | Thu, 08 Jan 2015 18:34:26 +0000 |
| Subject: | Re: How can I capture just the first record in a found set and edit it? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-324230@lists.php.net to get a copy of this message | ||
On Thu, Jan 8, 2015 at 1:00 PM, DealTek <dealtek@gmail.com> 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@gmail.com
> [db-15]
>
> To do it on the data side...
For mysql it'd be something like
select * from table order by date desc LIMIT 1
For mssql
select TOP 1 * from table order by date desc