I have a mysql database which has a table holding football team names and another table for setting up schedules. I am using a drop down list to pick the teams (a home team and an away team), so I’m using the same script twice on the page. I can retrieve the first team_id and post it in the database, but I don’t know how to get the 2nd team_id, so I can post them both at the same time from the same page.
This is the code that I’m using twice on the page (www.beat-the-spread.net/admin_editschedule.php).
The code is already placed in the .
I understand that “team_name” will return the team_id, but how do I assign different names so I can insert 2 separate id’s into the database? Hope that makes sense.
Thanks for any help!