Re: Why won't this query work?
| From: | Daniel Brown | Date: | Mon, 24 Mar 2008 18:23:47 +0000 |
| Subject: | Re: Why won't this query work? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-272046@lists.php.net to get a copy of this message | ||
On Mon, Mar 24, 2008 at 1:47 PM, Jason Pruim <japruim@raoset.com> 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_*().
--
</Daniel P. Brown>
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283