Page 1 of 1

league tables

Posted: Wed Aug 29, 2007 9:52 am
by kevrelland
hi guy's and girls
i'm putting together a site with a league table for multiple divisions, but only showing either for example div 1 or say a a user selects div 3 from a drop down menu.

basically i want to know how i can filter the results from my tables table to show a certain division that some one has selected

hope i have made it clear
cheers
kev

Posted: Wed Aug 29, 2007 1:51 pm
by Christopher
Use the SQL WHERE clause:

Code: Select all

SELECT * FROM teams WHERE div=1

Posted: Thu Aug 30, 2007 4:26 am
by kevrelland
sorry i didn't make it clear i want a button above the table to change the division number
i just unsure of how to do this
cheers
kev