[SOLVED] update enum field returns error

[tryingtolearn]

Not sure if this needs to be in this forum or the php help forum

 

Sorry if this is the wrong spot.

 

I have an UPDATE Query that is failing when I include two enum fields in the query

This updates the record w/ no problem

$query = "UPDATE page2 SET title='$t', info='$a', cat_id='$ca' WHERE id=$editid"; 
$result = mysql_query($query);

 

But when I do it like this(Show and access are enum fields)

$query = "UPDATE page2 SET title='$t', info='$a', cat_id='$ca', show='$sho', access='$ac' WHERE id=$editid"; 
		$result = mysql_query($query);

 

I get this error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'show='hide', access='public' WHERE id=32' at line 1

 

Query: UPDATE page2 SET title='ffgd', info='ff22ff', cat_id='27', show='hide', access='public' WHERE id=32

 

This query worked on a server running an older version of mysql - this just started when I moved to this server running

MYSQL Version  5.0.51a

 

Any ideas?

[tryingtolearn]

I should add

The table updates fine if I update it directly in phpmyadmin

Dont know if that helps narrow things down a bit.

[Mchl]

http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html

[tryingtolearn]

Well, I'll be damned!

Learn something new every day

Thanks Mchl