Re: Returns Blank
| From: | Martin Norland | Date: | Thu, 20 Jan 2005 21:54:07 +0000 |
| Subject: | Re: Returns Blank | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-38246@lists.php.net to get a copy of this message | ||
Squeakypants wrote:
From a forum that recommended this to me, I changed the query execution to this: $query = "SELECT credits FROM krypto WHERE user=$user AND pass=$pass"; echo "query = ". $query ."\n"; $result = mysql_query($query); echo "result = ". $result ."\n"; So now it outputs this: query = SELECT credits FROM krypto WHERE user=admin AND pass=xxxxxxxx result = Could not run query: Unknown column 'admin' in 'where clause' Quotes are your friend. admin is a string, not a field. Also, it's not bad practice to backtick the database fields themselves.$query = "SELECT credits FROM krypto WHERE
user='$user' AND pass='$pass'";
You'll want to try to read your error messages a little harder in the future, FWIW.
Cheers,
--
- Martin Norland, Database / Web Developer, International Outreach x3257
The opinion(s) contained within this email do not necessarily represent
those of St. Jude Children's Research Hospital.