[thelist] mysql_affected_rows();

[Dunstan Orchard]

This is odd.

I'm running an update query on a mysql database.

// images query
$sql = ("UPDATE images SET title = '$title', date_shot = '$date_shot' WHERE
imageid = '$imageid'");

// run query
mysql_query($sql);

// count rows affected
$noar = mysql_affected_rows();

// do errors
if ($noar == '0')
	{
	$edit_images_update_error = "1";
	}
else
	{
	$edit_images_update_error = "0";
	}



If the data that's being updated has altered in any way then my number of
affected rows ($noar) returns true and my error = 0.

If the data hasn't changed, then $noar == 0, and my error = 1.


Does php/mysql compare my data then and decide that as it's the same it
doesn't need updating?

I don't get it?

Thanks - dunstan

---------------------------
Dorset, England
http://www.1976design.com/
http://www.orchard.it/
http://www.maccaws.org/