Unknown column in 'where clause'

[rocket_rob]

I receive this message ONLY when prodid is alphanumeric. If prodid is 1234 or 1234-100 I get no errors but when it has an alpha character it errors out (ex. 0850V, P1-100).

This is the code in question.

$colors = mysql_query("SELECT COLOR FROM colors WHERE PRODID =".$row_products['PRODID'], $connection) or die (mysql_error());

And the error is: Unknown column '0850V' in 'where clause'

My PRODUCTS table has one record for each product, while my COLORS table may have multiple records for a product.

It seems like there is a problem with the quotes but I cannot get this working properly. Any help is appreciated.

[lazzerous]

go into the db and write this is:

desc table_name;

replaceing 'table_name' with the name of your table.

Copy what it spits out and give it to us

you might have that field in the table set as ini

if you want that field to handle alpha-numeric, it needs to be set to varchar