[SOLVED] Need help with update error

[jim.davidson]

I use Dreamweaver8, PHP, and mySQL 4.1.21

 

I'm getting this error when I try to update a record

 

Unknown column 'y' in 'field list'

 

I've tried everything, I can't figure out what's wrong...Please help

 

Background

Fields for orders table

order_id   int(10) auto increment  Key field

received  enum('n','y') Default n

received_by int(10) Default 0

 

variables

$currentuser = 1

$upDateReceived = y

$upDateOrder = 32

 

Here's the code

 

$updateSQL = "UPDATE orders SET received_by = $currentUser, received = $upDateReceived WHERE order_id = $upDateOrder";

mysql_select_db($database_imcrecycle, $imcrecycle);

$Result1 = mysql_query($updateSQL, $imcrecycle) or die(mysql_error());

 

[veridicus]

Wrap text in quotes...

 

$updateSQL = "UPDATE orders SET received_by = $currentUser, received = '$upDateReceived' WHERE order_id = $upDateOrder";

[jim.davidson]

Thank so much, that did it.  Sooner or later I'll catch on to when to use quotes.

 

Thanks agan