that command doesnt even work from the mysql command prompt for me, Ive never used LAST_INSERT_ID(), but it dont work for me. try it on your mysql command prompt.
-- Chris Lee [EMAIL PROTECTED] "Ise" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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 > Institute for Social Ecology > http://www.social-ecology.org/ > > 1118 Maple Hill Road > Plainfield, VT, 05667 USA > > Tel.: 1 (514) 421-3515 > General Tel. / Fax.: 1 (802) 454-8493 > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]