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]

Reply via email to