Please help if ya can :)!!

[soupy127]

Hello there ! I am currently designing a golf website for my final year project.

 

What i am hoping to do is have is 2 drop down lists, one with the golfers names and the other with the name of the course (both of these list will be fed from the mysql database). then i want the user to be able to hit submit and it displaying that golfers results for that course?

 

any ideas how i would go about structuring the databases? and how i would go about coding the query?? any help would be greatly appreciatied as i dont even know were to start ! haha please help

 

thanks

[svgmx5]

well you want to write an sql script taht searches your db table for those two key fields.

 

So something like this...

 

$sql = "SELECT * FROM table WHERE golfer_name='$golfer_name' AND golf_course='$golf_course';

 

something like that..not sure thats what you want exactly, but that can be a start...i hope