Help Please
Posted: Sat May 22, 2004 3:18 am
Trying to come up with a complex query and output script, well complex to me anyway!
I have 2 tables - 1 matches, with details of the match, and 1 called clubs, with details of the clubs.
The script I am coding is a match editing panel. It queries the matches table to pull out the data which is all fine. The problem I'm having is with querying the clubs table. I need the output from there to be loaded into a dropdown list.
The club_id is stored in the matches table, which is basically used to look up details of the club (longname, shortname etc). The club appears in the panel as the opponent, so the club_id stored in the matches table needs to be selected in the dropdown list.
I have tried various loops etc with little success.
Hope this makes sense, but you can view what I'm trying to do here: http://www.brownwebsites.co.uk/AUFC/db/ ... &match=334
Use name: guest and password php
I have 2 tables - 1 matches, with details of the match, and 1 called clubs, with details of the clubs.
The script I am coding is a match editing panel. It queries the matches table to pull out the data which is all fine. The problem I'm having is with querying the clubs table. I need the output from there to be loaded into a dropdown list.
The club_id is stored in the matches table, which is basically used to look up details of the club (longname, shortname etc). The club appears in the panel as the opponent, so the club_id stored in the matches table needs to be selected in the dropdown list.
I have tried various loops etc with little success.
Hope this makes sense, but you can view what I'm trying to do here: http://www.brownwebsites.co.uk/AUFC/db/ ... &match=334
Use name: guest and password php