> $customer_select="SELECT * FROM customers WHERE Customer_No = $id";
This is more of a PHP question but here's what I would do.
$customer_select="SELECT * FROM customers WHERE Customer_No = '$id'";
OR
$customer_select="SELECT * FROM customers WHERE Customer_No = '".$id."';
if for some reason the first one didn't work.
HTH,
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
----- Original Message -----
From: "Shrout, Ryan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 18, 2001 2:14 PM
Subject: RE: Unknown column in 'where clause' error
> Thanks for the suggestions, but this is actually a variable that is passed
> via a URL. For example:
>
> http://localhost/cus-lookup.php?id=CMET3558539239
>
> Then in the code it looks like this:
>
> $customer_select="SELECT * FROM customers WHERE Customer_No = $id";
>
> How can I 'put quotes around' a variable?
>
> Ryan Shrout
>
> -----Original Message-----
> From: Bill "Elvis" Gibbs [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 18, 2001 3:20 PM
> To: Shrout, Ryan
> Subject: RE: Unknown column in 'where clause' error
>
>
> WHERE Customer_No = 'CMET3558539239'
>
> you need to use quotes when trying to reference data that is not 100%
> numeric, otherwise MySQL thinks you are trying to reference a column.
>
> Bill "Elvis" Gibbs
> goEbusiness.com - putting e-motion in your business
> email - [EMAIL PROTECTED] work - 301-668-5090 cell - 301-748-6938
>
> -----Original Message-----
> From: Shrout, Ryan [mailto:[EMAIL PROTECTED]]
> Sent: Monday, June 18, 2001 2:44 PM
> To: '[EMAIL PROTECTED]'
> Subject: Unknown column in 'where clause' error
>
>
> Here is the full error I am getting when running the query included:
>
> Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239
> 1054 : Unknown column 'CMET3558539239' in 'where clause'
> Here's the problem, I know that Customer_No exists. I can see it in the
> database. This code works fine when using a Customer_No such as 15 or
153,
> something numeric. The field itself is defined as a CHAR (50).
>
> Any ideas what is causing this? It happens with every Customer_No in this
> format and gives the same error.
>
> Ryan Shrout
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
