[SOLVED] Data deletes itself instead of updating

[dezkit]

I have found the problem.

[Maq]

Instead of using this:

 

$result=mysql_query("UPDATE events SET name='$name',date='$date',location='$location',description='$description',image='$image',time='$time',detail='$detail',site='$site',phone='$phone',image='$image' WHERE id='$id'");

 

Why don't you put the sql statement in a string, echo it out and use mysql_errors()

 

$sql = "UPDATE events SET name='$name',date='$date',location='$location',description='$description',image='$image',time='$time',detail='$detail',site='$site',phone='$phone',image='$image' WHERE id='$id'";
echo $sql;
myql_query($sql) or die(mysql_error());