update mysql table problem

[Anon]

Hi!

I've had some problems with my sql syntax. There occurs no errors, but the table does not get updated. The code looks like this :

$res = mysql_query("update arrangement set dato='$dato' and navn='$arrnavn' and ArrangementKategori='$kategori' and entre='$entre' and AntalPersoner='$antal' where id='$id'");

All the variables is posted via a form.
Can somebody please help me???

/Claus

[Anon]

Did you print your query to the screen to see just what you ware trying to do?

cahnge your code to this:

$query="update arrangement set dato='$dato' and navn='$arrnavn' and
ArrangementKategori='$kategori' and entre='$entre' and AntalPersoner='$antal' where id='$id'";

print $query;

if (!($res=mysql_query($query)))
{
echo mysql_errno().": ".mysql_error()."<BR>";
};

[Anon]

Hi Claus,

Did you solve this problem? I appear to be having the same problem, and I've narrowed it down to the updating of long_text fields. All the other field update ok.

Don't know why this is, but I was hoping you had found a solution.

Regards,

Nick Gushlow.