Re: PHP + MySQL - Load last inserts
| From: | Thijs Lensselink | Date: | Mon, 30 Mar 2009 12:53:23 +0000 |
| Subject: | Re: PHP + MySQL - Load last inserts | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-290821@lists.php.net to get a copy of this message | ||
Sebastian Muszytowski wrote:
> Hello :)
>
> I have some troubles with php and mysql. I have a normal MySQL Query
> and this returns X > 3 rows.
> Now i want to get the last 3 inserted values. For Example i've inserted
>
> A, B, C, D, E
>
> I want to get the last inserted values, e.g. E D C (in reversed order)
>
> So how to do this? I already searched the web and the whole php.net site
> but i don't see any workaround.
>
> Thanks in advance
>
> Sebastian
>
>
It's not really a PHP question. But here goes :
SELECT column FROM
table ORDER BY column DESC LIMIT 3