> Date: Mon, 30 Mar 2009 14:55:08 +0200
> From: s.muszytow...@googlemail.com
> To: p...@addmissions.nl
> CC: php-general@lists.php.net
> Subject: Re: [PHP] PHP + MySQL - Load last inserts
>
> 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
>
Hey Dude,
I'm sure you don't wanna complicate issues for yourself. You've been given two
correct ways to go about it. I think you should try those.
Ciao.
_________________________________________________________________
Drag n’ drop—Get easy photo sharing with Windows Live™ Photos.
http://www.microsoft.com/windows/windowslive/products/photos.aspx
