MySQL Native Function in PHP Query Not Working?

From: Date: Fri, 07 Dec 2001 20:52:52 +0000
Subject: MySQL Native Function in PHP Query Not Working?
Groups: php.general 
Request: Send a blank email to php-general+get-77084@lists.php.net to get a copy of this message
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

« previous php.general (#77084) next »