Re: last_insert_id function

So can I do either way as I show below here? first could be : $sql = "insert into user (name,email) values('Jack','god@mail.com')"; $result = mysql_query($sql); $sql1 = "insert into userFriend (userId,friendName,) values(LAST_INSERT_ID(),'John');" $result1 = mysql_query($sql1); or second way is: $sql = "insert into user (name,email) values('Jack','god@mail.com')"; $lastId = mysql_insert_id(); $result = mysql_query($sql); $sql1 = "insert into userFriend (userId,friendName,) values($lastId,'John');" $result1 = mysql_query($sql1); Are these correct? Jack jacky@activelifestyle.com "There is nothing more rewarding than reaching the goal you set for yourself" ----- Original Message ----- From: Maxim Maletsky <maxim.maletsky@japaninc.net> To: 'Jacky@lilst' <jacky@activelifestyle.com>; <php-general@lists.php.net> Sent: Wednesday, January 24, 2001 3:25 AM Subject: RE: [PHP] last_insert_id function > for example: > > $SQL = "INSERT INTO users SET name='Maxim', surname='Maletsky'"; > > now you have to insert into another table where you need to relate that user > to the entry: > > $SQL2 = "INSERT INTO questions SET question='how did you sleep?', > made_by=LAST_INSERT_ID()"; > > LAST_INSERT_ID() will be here equal to the auto_incremented id of the first > $SQL statement. > > Hope this helps, > Maxim Maletsky > > > -----Original Message----- > From: Jacky@lilst [mailto:jacky@activelifestyle.com] > Sent: Thursday, January 25, 2001 7:16 AM > To: php-general@lists.php.net > Subject: [PHP] last_insert_id function > > > I got this quote right out of the php manual. My Id field happen to be type > BIGINT as it said so I tried using LAST_INSERT_ID(); and turn out to be > error said "unidentified function". Any clue? > ******************************************* > mysql_insert_id() converts the return type of the native MySQL C API > function mysql_insert_id() to a type of long. If your AUTO_INCREMENT column > has a column type of BIGINT, the value returned by mysql_insert_id() will be > incorrect. Instead, use the internal MySQL SQL function LAST_INSERT_ID(). > ******************************************** > Jack > jacky@activelifestyle.com > "There is nothing more rewarding than reaching the goal you set for > yourself" > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net >