Go Back   CodingForums.com > :: Server side development > PHP

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 03-27-2003, 09:19 PM   PM User | #1
Silver
New Coder

 
Join Date: Mar 2003
Location: Somerset, UK
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Silver is an unknown quantity at this point
Basic Search

I've made a basic page using mySQL and PHP for a Tennis Site.

The person I'm making it for would like to add a search where they can search for a team name from a list or drop down if possible and get all the results from that team. That alone would be ok but if they could also search for season and league that would be even better! How can I do this?

Thanks for any help!
Silver is offline   Reply With Quote
Old 03-27-2003, 09:20 PM   PM User | #2
Silver
New Coder

 
Join Date: Mar 2003
Location: Somerset, UK
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Silver is an unknown quantity at this point
Just remembered something -

It would be searching the mySQL database
Silver is offline   Reply With Quote
Old 03-27-2003, 09:24 PM   PM User | #3
Spookster
Supreme Overlord


 
Spookster's Avatar
 
Join Date: May 2002
Location: Marion, IA USA
Posts: 6,224
Thanks: 4
Thanked 80 Times in 79 Posts
Spookster will become famous soon enough
Query the database for team names and populate a dropdown box from the query. When they select a team name use that value in your query to the database for the rest of the information.

As for searching by league and season, is this a completely separate search from the team? Or did you mean....Find this team and then filter by season and league?
__________________
Spookster
CodingForums Supreme Overlord
All Hail Spookster
Who gave you that Ugging infraction? Yeah that's right it was me!
Spookster is offline   Reply With Quote
Old 03-27-2003, 09:37 PM   PM User | #4
Silver
New Coder

 
Join Date: Mar 2003
Location: Somerset, UK
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Silver is an unknown quantity at this point
Sorry - just realised I put this in the PHP forum, I meant to put it in the mySQL one! But anyway now I'm here

We just had a quick rethink - this is plan two

We need to be able to search for Team but NOT Division together with Season but NOT League.

So people can search for Mens II (the Team) and Winter '00 (the season) and get the results for them. If they want they can just search for Mens II but they'll get about 5 sets of results.

Please make it as simple as you can as I'm still new to this stuff. Thanks for your help!
Silver is offline   Reply With Quote
Old 03-28-2003, 03:44 AM   PM User | #5
stoodder
Regular Coder

 
Join Date: Oct 2002
Location: Milwaukee, Wisconsin
Posts: 123
Thanks: 1
Thanked 0 Times in 0 Posts
stoodder is an unknown quantity at this point
hmmm i could write up a little script for you... um do youhave a mysql database and if so please tell me the table name and all of its column names please and tell me what each is ill get it for ya!!! lol i think... no im JK i will than btw for letting me hopefully
stoodder is offline   Reply With Quote
Old 03-28-2003, 01:52 PM   PM User | #6
Silver
New Coder

 
Join Date: Mar 2003
Location: Somerset, UK
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Silver is an unknown quantity at this point
Thanks stoodder

It's currently a database called kailyn_tennis and has a table called results in it.

Thanks! If you need to know anything else you can either post here or drop me an email at vprince@NOSPAMbtinternet.com, obviously remove the NOSPAM

Thanks again
Silver is offline   Reply With Quote
Old 03-28-2003, 01:53 PM   PM User | #7
Silver
New Coder

 
Join Date: Mar 2003
Location: Somerset, UK
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Silver is an unknown quantity at this point
Oh yes and columns, in this order -


id, date, league, season, team, division, opponent, outcome, score, ip
Silver is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 09:11 AM.


Advertisement
Log in to turn off these ads.