Re: PHP + MySQL - Load last inserts

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux