[snip]
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.
[/snip]
In your PHP page where you are inserting into the other table create a
drop-down box to select teams entered into the DB already. Drive the
drop-down with
select team_id, team_name
from tblTeam
order by team_id
click on the team, add the extra info, submit and voila!
Jay
