mysql_insert_id( )

Anon

I have a small application using a two table database. one table in client_info and has clientID INT not null auto-increment as the Primary Key. The other table is contact_info and has contactID INT not null auto-increment as its Primary Key. Both are unsigned.

I am trying to use either mysql_insert_id() or mysql function LAST_INSERT_ID() to grab the clientID from client_info and insert it into contact_info as a foreign key. If I issue SQL statements from the command line it works. If I do this from PHP it also works but the clientID gets inserted into contact_info with a value of 0. Does anyone know why or have any help they can offer?

Thanks,

Tom

gushy

without seeing your code it's difficult to tell, but I use mysql_insert_id() with no problems. You code should look something like:

// assuming columns x,y,z aren't the
// auto-increment column
mysql_query("
INSERT INTO table1(x,y,z)
VALUES('1','2','3')
");

// get last insertion id
$ID = mysql_insert_id();

// insert into new table
mysql_query("
INSERT INTO table2(table1_id,a,b,c)
VALUES('$ID','1','2',3')
");

// all done.

-- Nick Gushlow

Anon

thanks, I'll try that. I did it a bit different. I used mysql_insert_id() to get the $clientID from my database and tehn I passed it through a URL into another form. After that I used a hidden field to extract it from the URL and pass it to the final script. Not very elegant but it works.