Re: PHP + MySQL - Load last inserts

From: Date: Mon, 30 Mar 2009 12:55:08 +0000
Subject: Re: PHP + MySQL - Load last inserts
References: 1 2  Groups: php.general 
Request: Send a blank email to php-general+get-290823@lists.php.net to get a copy of this message
Thijs Lensselink schrieb:
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 Oh okay thank you very much :)
I thought I must do this with php and some sort of mysql_fetch_asssoc or something like this

« previous php.general (#290823) next »