Well, you don't need the distinct.
Are you inserting with your PHP script? LAST_INSERT_ID(), as per the manual,
only returns the id from the last insert on that connect. You cannot get the
LAST_INSERT_ID() for another connection.
j----- k-----
On Wednesday 05 May 2004 05:11 pm, Erich Beyrent said something like:
> Hi there,
>
> I seem to be having a problem retrieving the last inserted ID for a
> table.
>
> The query I am using is as follows:
>
> mysql> select distinct LAST_INSERT_ID() as LastID from listings;
> +--------+
>
> | LastID |
>
> +--------+
>
> | 3575 |
>
> +--------+
> 1 row in set (0.00 sec)
>
> However, when I run this from my PHP script, I get a value of 0.
>
> Any clues as to how to resolve this?
>
> Thanks!
>
> -Erich-
--
Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295
Every knee shall bow, and every tongue confess, in heaven, on earth, and under
the earth, that Jesus Christ is LORD -- Count on it!
