UPDATE problem

I cannot figure out what is wrong with this code. Please help

$q = "UPDATE profiles SET label = '$label', email = '$email', show_email = '$se', bio = '$bio', show = '$show' WHERE id = '$id'";
mysql_query($q) or die("What's wrong with this thing!?");

Is there an error? What's not working?

it works except for the show = '$show'

is that some kind of keyword or something?

So you mean that the value in $show does not appear in the 'show' field for the updated row? If so, what value did $show have before you inserted it into your query string?

Usually it helps for debugging to assign the whole query string to a variable and print that to see what the query really looked like.

I changed show to show_p in my table and it works. It seems show is some kind of keyword or something?

show is a syntax that mysql can use - used for outputting information on the table/database. Though, so saying that, I'm a tad surprised that a field cannot be named it. If that were the case you wouldn't be able to name a field 'delete' and I'm pretty sure that I have before.

SHOW syntax in the manual (http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#SHOW)

Have a look here, this is the list of reserved words used by MySQL. Show and Delete are in fact there:

http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html#Reserved_words