>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.

I guess you have a numeric primary key with auto_increment activated.
Then just order your select by that primary key in descending order and limit 
the output to 3.

For instance:

FROM table
ORDER BY primary_key DESC
LIMIT 0, 3;

Greetins from Germany


Sync and share your files over the web for free

My Twitter feed

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

Reply via email to