I'm building a system that inserts new members to a mySQL table which auto-increments and creates the new member_id. I'd like to know what that number is immediately (using it on the "Thanks for Joining" page). Is it possible to get that number without making a second query to the database using the member's last name and other information to pull the member_id? Many Thanks!
Hate to say it, but RTM. There's a "last insert id" function.
OK, OK, but I'm a relative newbie and I never would have found it. This is exactly what I need, thank you!
CJ, two resources that'll help you find things, newbie or not: http://www.php.net, has a complete function list. You can find anything you need here. http://www.mysql.com, has very good documentation.
