LAST_INSERT_ID() only works in a select. This should be the correct syntax, but MySQL 3.xx.xx doesnot support SubQueries. I believe that MySQL 4 does or will in the near future.
SELECT * FROM table WHERE aid=(SELECT LAST_INSERT_ID()) Jerry Verhoef -----Original Message----- From: Chris Lee [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 6:45 PM To: [EMAIL PROTECTED] Subject: [PHP] Re: MySQL Native Function in PHP Query Not Working? 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] The information contained in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any form of disclosure, production, distribution or any action taken or refrained from in reliance on it, is prohibited and may be unlawful. Please notify the sender immediately. The content of the email is not legally binding unless confirmed by letter bearing two authorized signatures. -- 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]