Is there a way to get the last Record # created by the DB.
Example:
User_ID = auto_increment
f_name = varchar
l_name = varchar
e-mail = varchar
b_date = varchar
pic = varchar
Since user_id is an auto_inc field I submit it as a NULL, also I haven't
started the code for a picture yet either so I have it set to NULL at this
moment.
My code is:
$query = "INSERT INTO `t_users` (`user_id`, `f_name`, `l_name`, `e_mail`,
`b_date`, `pic`) VALUES ('', '$f_name', '$l_name', '$e_mail', '$b_date',
'')";
$result = mysql_query($query);
if(!$result)
{
die("Could not query the database: <br/>".mysql_error());
}
echo "Your Player information has been stored OK.<br />";
what code could I add here to make the following line work?
echo "REMEMBER your USER ID# you will need it when creating Characters!! It
is: $user_id"; <----- I want to show the "user_id" just created here.
Thanks in advance!
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
