Hi-
I am trying to insert information into mysql based with the sql queries
below. When I run this insert from the mysql console everything works
correct, however, when I run this through php the second sql query doesn't
execute (I'm assuming there is a problem with the last_insert_id()).
I have tried changing the "last_insert_id()" to a "mysql_insert_id()"
function with no success?
How do I get this to work?
Thanks in advance,
Max
$sql1 = "insert into transport (domain,transport) values
('$domain','$transport')";
$sql2 = "insert into acl (adminId,transportId,securityId) values
('$userid',last_insert_id(),'1'";
mysql_query($sql1);
mysql_query($sql2);
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
