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
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