On Mar 24, 2008, at 2:23 PM, Daniel Brown wrote:
On Mon, Mar 24, 2008 at 1:47 PM, Jason Pruim <[EMAIL PROTECTED]> wrote:
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'"
[snip!]

   Encapsulate your $business variable in quotes.  If you don't,
MySQL sees it as a relational link.

   Also, as a reminder, be sure to use
mysql_real_escape_string($business) if you're not using mysqli_*().

It's already been escaped, $business is pulled out of the database after they log in. :)




--
</Daniel P. Brown>
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283


--

Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424-9337
www.raoset.com
[EMAIL PROTECTED]




--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to