Why won't this query work?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxx




[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux