NYCPHP Meetup

[nycphp-talk] MYSQL SELECT Error Question

Steve Soler steve at soler.com
Thu Feb 27 22:19:52 EST 2003


Yes!  This was exactly it!  I admit I'm still learning (right out of a 
book I might add.) But it's amazing how some books leave out the 
simplest details, which cause the biggest headaches (when you are just 
learning).  Thank goodness for this forum! You guys rock! ;-)

Thanks all!
- Steve

On Thursday, February 27, 2003, at 09:51 PM, Jim Hendricks wrote:

> You need to delimite Service since it is a constant and not a data 
> column.
>
> ie. mysql> select * from Members where Business_Type = 'Service';
>
> Jim
> ______________________________________________________________
> Jim Hendricks, President, Biz Computing, Inc
> Phone:  (201) 599-9380     Email: jim at bizcomputinginc.com
> Web: www.bizcomputinginc.com
> Snail:  Jim Hendricks,  Biz Computing, Inc.,  255 McKinley Ave, New 
> Milford,
> NJ 07646
> ______________________________________________________________
>
>
> ----- Original Message -----
> From: "Steve Soler" <steve at soler.com>
> To: "NYPHP Talk" <talk at nyphp.org>
> Sent: Thursday, February 27, 2003 9:47 PM
> Subject: [nycphp-talk] MYSQL SELECT Error Question
>
>
>> Can anyone help me decipher this error I'm getting in MYSQL?
>> I'm certain there are rows in my database that contain the word
>> "Service" in the "Business_Type" column.
>>
>> Below is the Select command and the error I'm getting. It's copied
>> right of my Telnet program.
>>
>> mysql> select * from Members where Business_Type = Service;
>> ERROR 2000: Unknown column 'Service' in 'where clause'
>>
>>
>> Thanks in advance,
>> - Steve
>>
>>
>>
>>
>>
>>
>>
>>
>
>
>
> --- Unsubscribe at http://nyphp.org/list/ ---
>
>




More information about the talk mailing list