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