really anoying help can it be done?

[stuckwithcode]

why does this not work

$name = "john";

mysql_query("UPDATE table SET user = '$name'text WHERE id = '5'"); 

 

how can i get the query to insert the variable and the text eg johntext into the table

[merylvingien]

Can you clarify what you are trying to do?

 

You want to update the user table with the $name variable. I get that, but whats "text"?

Is text another variable?

[stuckwithcode]

no text is just some text that i want to be added to the end of the varaible

[litebearer]

then use $new_var = $var1 . $var2 before you update

[stuckwithcode]

I understand that method but was wondering if you can do it in the one line

[trq]

mysql_query("UPDATE table SET user = '{$name}text' WHERE id = '5'");

[stuckwithcode]

that did it, cheers buddy