Why won't this query work?
| From: | Jason Pruim | Date: | Mon, 24 Mar 2008 17:47:12 +0000 |
| Subject: | Why won't this query work? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-272042@lists.php.net to get a copy of this message | ||
Hi Everyone,
Attempting to get this query:
"SELECT customerName, loginName, email, adminLevel FROM current WHERE customerBusiness=$business ORDER BY adminLevel"
to work.
So far it doesn't like me... It pops up saying that "Unknown column 'Raoset' in 'where clause'"
Here is what I get if I echo the query:
SELECT customerName, customerBusiness, loginName, email, adminLevel FROM current WHERE customerBusiness='Raoset'
$business is populated from a session variable and echos right... What I can't figure out is what in the world is wrong... If I type in the variable info, it works just fine. So why can't I pull it from a variable?
--
Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
japruim@raoset.com