I can't UPDATE MySQL db fields

define("TABLENAME","soreal");

$db=mysql_connect(localhost,root,password);
mysql_select_db("mydb",$db);

if (!$result=mysql_query('UPDATE '.TABLENAME.' SET name = "'.$name.'" , area = "'.$area.'" , kind = "'.$kind.'" , money = "'.$money.'" , $file_description = "'.$file_description.'" WHERE ID = '.$id,$db)){
echo "<p><h1>Error, I haven't change the fields</h1></p>";
} else {
echo "<p><h1>Fields changed</h1></p>";
}
mysql_free_result($result);

Output will be <p><h1>Error, I haven't change the fields</h1></p> :

WHY????? (if I do on a mysql client 'UPDATE '.TABLENAME.' SET name = "'.$name.'" , area = "'.$area.'" , kind = "'.$kind.'" , money = "'.$money.'" , $file_description = "'.$file_description.'" WHERE ID = '.$id (OF COURSE, I CHANGE THE VARIABLES BY THE VALUES) and works!!!! )

PS: Sorry my bad english ;-)

Try this statement:

if (!$result=mysql_query("UPDATE $TABLENAME SET name='$name', area='$area', kind='$kind', money='$money', file_description='$file_description' WHERE id='$id'",$db)) {

1. You had also an error in the part >>>$file_description=".'$file_description'.<<< take away the first "$" !!

2. You have not closed the statement with "'" !!!+

Hope it works

<BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by pwluky:
Try this statement:

if (!$result=mysql_query("UPDATE $TABLENAME SET name='$name', area='$area', kind='$kind', money='$money', file_description='$file_description' WHERE id='$id'",$db)) {

1. You had also an error in the part >>>$file_description=".'$file_description'.<<< take away the first "$" !!

2. You have not closed the statement with "'" !!!+

Hope it works[/quote]

Thanks ;-) I "think" the problem was the "$file_descrition" but I'm not sure...

------------------
{C00L|Z3R0} on irc.ptnet.org