On Mar 16, 2007, at 10:28 PM, Jeff wrote:
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!
For auto increment values, you don't have to specify the id. For
example:
INSERT INTO t_users (f_name, l_name, e_mail, b_date, pic)
VALUES ('$f_name', '$l_name', '$e_mail', '$b_date', null);
Then to find the latest entry:
SELECT user_id FROM t_users ORDER BY user_id DESC limit 1;
Hope that helps.
~Philip
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
