soupy127 Posted May 23, 2010 Share Posted May 23, 2010 Have 2 problems that i am currently having trouble with and i have to have these sorted by monday so stressing out, the first is I have a table called users and a table called courses (golf courses) so goin to make a results table combining both so that it can display the users result for that specific course. Wanting to have on the webpage 2 list boxes so that the admin can select the user from the first list and then select the course from the second list and then it will display the users result for that course? just wandering how i would go about doing this... the 2nd question is that I have put the website up on to a free hosting website and they gave me a connect url for phpmyadmin so that my database will work with the site, but when the php scripts are coming up duffers.users table does not exist? (duffers being the name of the database and users being the name of the table) but it seems like it is connecting to the database but just isnt recognising the tables :S any ideas? PLZZZZ Help im desperate haha. it will be greatly appreciated. Quote Link to comment https://forums.phpfreaks.com/topic/202618-please-help-im-desperate-have-1-day-to-get-this-working/ Share on other sites More sharing options...
jcbones Posted May 23, 2010 Share Posted May 23, 2010 1. Use table joins http://dev.mysql.com/doc/refman/5.0/en/join.html 2. Are you sure the database has the tables? 3. Are you sure the table is named users, and not user, or Users. Quote Link to comment https://forums.phpfreaks.com/topic/202618-please-help-im-desperate-have-1-day-to-get-this-working/#findComment-1062146 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.