On Wednesday, 8. May 2002 17:01, Steve Buehler wrote:
> I am running mysql with a php frontend. I am trying to add teams to a
> table and when I do, it gives them a team_id number that is in an
> auto_increment column. This is no problem. The problem is that I need to
> know that team_id so that I can also enter the team_id into another
> table. Any help would be appreciated.
>
http://www.mysql.com/doc/m/y/mysql_insert_id.html
or for php
http://www.php.net/manual/en/function.mysql-insert-id.php
Regards
Georg
