MySQL Native Function in PHP Query Not W

[Anon]

Hello,

Can someone explain to me why the below SQL query when executed with the PHP mysql functions does not work? (it returns nothing)

SELECT * FROM table WHERE aid=LAST_INSERT_ID()

If I replace the MySQL function "LAST_INSERT_ID()" with a integer, it works fine so its not the query. Further, I was returned results on the above query when I ran it directly from a MySQL client. Does PHP not support certain MySQL native functions?

Thanks,

Michael Caplan

[[deleted]]

PHP just relays the query, it does not parse it or anything.

So LAST_INSERT_ID() does work.

Can you post a PHP codesample?