On Mar 24, 2008, at 2:23 PM, Daniel Brown wrote:
On Mon, Mar 24, 2008 at 1:47 PM, Jason Pruim <japruim@xxxxxxxxxx>
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
japruim@xxxxxxxxxx
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
