Re: Returns Blank

From: 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.

« previous php.db (#38246) next »