[SOLVED] I have a problem using my UPDATE the right way.

[Redlightpacket]

I need some help trying to get my UPDATE to work the right way for this particular piece of code. I am really confused here.

 

$array = array('p', $user);
$com = join("", $array);

//test me
echo $com;


$query = "CREATE TABLE IF NOT EXISTS $com(id SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY, bio VARCHAR(450), idea VARCHAR(450), location VARCHAR(50))";

$table1 = mysql_query($query)
or die("Query failed: ".mysql_error());


//$query = "UPDATE $com SET idea = $idea, bio = $bio, location = $location, WHERE id = "1"";


//Here is my update statement, when I run the script, it says there is an error in this line.

$result =  mysql_query("UPDATE $com SET bio = '$bio', idea = '$idea' location = '$location' WHERE id = '1'")
or die(mysql_error());

[Redlightpacket]

I figured it out, but thanks for the time to look at my post.

[Maq]

Please share.  Also, you should mark as SOLVED if that's the case.