Table updating without query

[pederdin]

I have a query:

$sql=mysql_query("update bookings set status=0,placed=0 where id=$booking");

This is the only query where status=0 is mentioned. Now I have a customer that says that the booking has been cancelled (status=0) without her pressing the button 'cancel booking'.

I would say she is lying except that placed is not set to 0 which would have been the case if she had pressed the button. Is there any way that a table can be updated without a query telling it to update?

or can a query, without mentioning 'status' still affect that column? I'm totally confused.

Regards
Peder

[blinkk]

There is no reason for a table to update its self. If she is not lying, then chances are you accidently set something in another query. Or she lied.

[psycorpse]

is the status field set with something in the beginning? does it automaticaly set itself to 1 or something? if it is blank that could be messing with your code as well. For instance if you use code like this:

if($status == "1"){
echo "something";
}else{
echo "this has been deleted";
}

[rachel2004]

I have not heard of tables updating themselves, so the problem is elsewhere.

I looked at your $sql line and it looks fine. So the problem is not there.

The script may be doing what you're telling it to do, but what you told it to do is not what you thought it would do... there's no way for someone to tell without looking at the logic.

Post your code if you want someone to analyze.