php questions

by solidsoul

Posted: 15 years ago 6 replies

PROGRAMMING

trying to figure out something regarding this short script that is just accessing a DB and querying it...

I'm getting the error that the table don't exist?? so my question is in this example how would you target the table in question

the DB is anxiety_questions then inside that DB there are two tables
1) questions
2) user details (note the space)

now when I use

mysql_query("SELECT first name FROM user details") or die("Sorry Couldn't Select Anything: " .mysql_error());

Hmm Something Went Wrong Not Sure What Lets Check: Table 'anxiety_questions.user' doesn't exist

#php #questions

KirkMcD 15 years ago

There is a space between user and details. There shouldn't be. What is the true table name?
Possibly user_details?
- Thanks
{{ DiscussionBoard.errors[5798800].message }}
solidsoul 15 years ago

Nope check image here..
- Thanks
Signature

Canadian Installment Loan Affiliate Program | High Conversions
{{ DiscussionBoard.errors[5798982].message }}
metallic07039 15 years ago

Put user details within grave accent marks like this:

mysql_query("SELECT first name FROM `user details`")
- Thanks
{{ DiscussionBoard.errors[5798991].message }}
solidsoul 15 years ago

nevermind got it... mysql_query("SELECT * FROM`user details`") or die(mysql_error());
- Thanks
Signature

Canadian Installment Loan Affiliate Program | High Conversions
{{ DiscussionBoard.errors[5799000].message }}
metallic07039 15 years ago

Originally Posted by solidsoul

nevermind got it... mysql_query("SELECT * FROM`user details`") or die(mysql_error());

That solution looks familiar. :-)
- Thanks
{{ DiscussionBoard.errors[5799021].message }}
WF99 15 years ago

have no idea what to do ...
- Thanks
{{ DiscussionBoard.errors[5901347].message }}