Having problems using variables in my queries

[ghosttr]

I am having problems using variables in my my sql queries, and i dont know what im doing wrong.

 

This works

//Database Connection
$query = "UPDATE INTO TABLE <table> WHERE id='102441019' SET color ='FFFF00'";

 

But the same thing using a variable does not ??? ???

//Database Connection
$1="FFFF00";
$query = "UPDATE INTO TABLE <table> WHERE id='102441019' SET color ='$1'";

 

 

[hvle]

$1 is a number one or an L?

 

You can't name a variable begin with a number

 

[hvle]

Also read the manual on SQL language, 

 

"update TableName set .... where (condition)"

[ghosttr]

ok i got that working

 

But that just lead to other problems  :'(

 

I have a list of names that i get from the database in the first column

In the second column i have text displayed as a color, also from the db.

The form lets you select a different color and change it, and it refers to the name.

 

Is there a way to specify the name in the form?