CJ,
I am fairly new to PHP and MySQL but there are 2 functions that can do this.
PHP has a function called mysql_insert_id to retreive the last ID and Mysql
also has last_insert_id() which you can use in your query. I have used
last_insert_id() with pretty good success but I would still recommend you
look at the documentation for these functions. This example for
last_insert_id() is off the top of my head.
insert into table1 (PrimaryID,Field) would be the initial insert
insert into table2 (PrimaryID,last_insert_id(),field) where
last_insert_id is the value for the foreign key
Hope this helps and let me know if you have any other questions.
Jason
J. Wharton [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I encountered something similar. Here is a snippet of code:
$tdate=date(Y\\-m\\-d);
$time=date(G\\:i\\:s);
$query=insert into trackinginfo (IP_Address, username, date, Time,
Processed, CommentFlag)
values ('$REMOTE_ADDR', '$username', '$tdate', '$time', 'N',
'$commentExists');
mysql_query($query) or die(mysql_error());
//RecordID is an auto incrementing primary key.
$query=select RecordID from trackinginfo where IP_Address='$REMOTE_ADDR'
and username='$username'
and date='$tdate'
and Time= '$time';
//used those variables as they are static for the page. And yes, that is a
bit of overkill you see there.
$result = mysql_query($query) or die(mysql_error());
$dummyvar = mysql_fetch_object($result);
$sid=$dummyvar-RecordID;
Cj [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
is there any way to determine the primary key of a row after it's added
to
a
table in mysql?
i need to do this because i have another table which requires the id
from
one table as a foreign key.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
