last problem - update query problem

[aebstract]

if (!$problem) {

$change_bgcolor = $_POST['change_bgcolor'];
$change_modified = date(U);
$edit = $_GET['edit'];


$query = "UPDATE albums SET bgcolor=$change_bgcolor, date_modified=$change_modified WHERE superid=$edit";
$r = mysql_query ($query);

header("Location: index.php?page=album&album=$edit");
exit();

}

This is the process that updates the database with the information.

 

Here is the form for this:

<form action=\"index.php?page=edit&edit=$edit\" method=\"post\">
Current color: $album_bg_color<br />
<input type=\"text\" size=\"6\" maxlength=\"6\" name=\"change_bgcolor\" />
<br />
<input type=\"submit\" name=\"submit\" value=\"submit\" />
</form>

 

It is submitting the timestamp that is being created by $change_modified in to the bgcolor and the last modified columns.. I am trying to get the form field to enter in to bgcolor. I also can't get it to set the variable to "#ffffff" vs "ffffff". How can I get the # in front of the value that they enter? Thanks!

[ohdang888]

$query = "UPDATE albums SET bgcolor='$change_bgcolor', date_modified='$change_modified' WHERE superid='$edit' ";

 

and...

 

mysql_query($query) or die(mysql_error());

[aebstract]

How do I get the # in front of the value?

[ohdang888]

$change_bgcolor = '#'.$_POST['change_bgcolor'];