Update

[[deleted]]

hi, any one like to help me with update a table in mysql.

I tried:
$query = "UPDATE table veckansmenu Set ('$year','$week','$rad1','$rad2','$rad3','$rad4','$rad5','$specoffer')where week ='$veckan' ";
$result = mysql_query($query)
or die("Ditt GICK INTE.");

First I tried:
$query = "UPDATE table veckansmenu ('$year','$week','$rad1','$rad2','$rad3','$rad4','$rad5','$specoffer');
$result = mysql_query($query)
or die("Ditt GICK INTE.");

please help, and thanks leslie.

[[deleted]]

Have a peek at the mysql manual, and read how the update syntax works:

http://www.mysql.com/doc/en/UPDATE.html