soupy127 Posted April 26, 2010 Share Posted April 26, 2010 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 Quote Link to comment Share on other sites More sharing options...
svgmx5 Posted April 26, 2010 Share Posted April 26, 2010 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.