I have a list box that shows all the venues available, I also have tables of results generated from mysql database for each of these venues.
Currently I just have links to each new table which is on a seperate web page, but I really need to generate a listbox that shows all the venues and then deending on which is selected have a table generated to show the results that correspond to the selection.
I have the list box working, but am stumped as to how i dynamically change the mysql query.
The query I use is below, the bit I need to dynamically change to match the listbox is the Venue.VenueName in this instance 'The First & Last'
Thanks a million (well 250 at least!)
$query = "SELECT SUM(Position.Points), Results.Date, Player.FirstName, Player.LastName, COUNT(Results.MembershipNo)
FROM Position, Player, Results, Venue
WHERE Player.MembershipNo = Results.MembershipNo
AND Results.Position = Position.Position
AND Venue.VenueID = Results.VenueID
AND Venue.VenueName = 'The First & Last'
GROUP BY Player.MembershipNo
ORDER BY SUM(Position.Points) DESC";