general $var problem with SQL UPDATE ..

[Anon]

Ok this is what i need:
I have a textfield called 'group$i'
$i = unique

I want to execute a SQL QUERY where i UPDATE the database record with the value read from the 'group$i' textfield

Normally this could be done this way
UPDATE articles SET group = '$nametextfield' WHERE ....

but since i use the var $i in the textfield's name, it would be something like this:

UPDATE articles SET group = '$group$i' WHERE ...

This does NOT work! If i exec this i get the value of $i in the database field.

What i want is the value of the textfield called group$i

Anybody has any idea's how to do this.

In gereral i need this:
if
$var="test"
$test = "Hello World"
echo $($var); should echo "Hello World"

[leatherback]

Guess what you might be loking for is:

$name = "group";
$name .="$i" // Or (string)$i

Update articles set group = "$name";

Is this what you are looking for?

Jelle