league tables

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
kevrelland
Forum Commoner
Posts: 73
Joined: Mon Jan 08, 2007 7:41 am

league tables

Post 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
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Post by Christopher »

Use the SQL WHERE clause:

Code: Select all

SELECT * FROM teams WHERE div=1
(#10850)
kevrelland
Forum Commoner
Posts: 73
Joined: Mon Jan 08, 2007 7:41 am

Post 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
Post Reply