morning

im trying to update a from a form using php with works well for everything other then the TEXTarea i am using in the form to a text tpye field in the database just wonted to no if im using the right query

if (isset($_POST['desc'])){
     $value_desc = trim($_POST['desc']);
     if (!empty($value_desc)){
     $query_desc = "UPDATE hotels SET desc = '$value_desc' WHERE name = '$id'";
         mysql_query($query_desc) or die(mysql_error());
     }
}

this is the error message i get so i guess it is the quary that is wrong

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc = 'this is a test' WHERE name = 'king'' at line 1

any ideas

cheers
mark jonas

Hi Mark,

"desc" is a reserved word in MySQL and therefore, IMHO not a very good choice for a column name.

You should be able to get the query working by surrounding desc with `, e.g. SET `desc` = '$value_desc'

HTH,

Chris

LOL o now i fill stupid LOL well at least i can say im a beginner and now to sort the dad out the name them coloums in the database LOL

cheers for that mate

mark jonas