Last inserted ID

[Erich Beyrent]

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-