[RESOLVED] mysql update not always working?

[jasondavis]

My code works most the time but occasionaly it does not update a users count, this is a weird issue but very important to get resolved, any ideas what would cause this

$sql2= "update friend_user_photo set comments=comments + 1 WHERE auto_id='$photoid'";
executequery($sql);

[NogDog]

No way to tell with that information. I would suggest you do some error logging with some meaningful debug output to help you determine which queries are not working.

$sql2= "update friend_user_photo set comments=comments + 1 WHERE auto_id='$photoid'";
$result = executequery($sql);
if(!$result)
{
   error_log("Query failed: [$sql2] " . mysql_error() . "\n", 3, __FILE__ . ".errors");
}
elseif(mysql_affected_rows() == 0)
{
   error_log("Query worked but no rows updated [$sql2]\n", 3, __FILE__ . ".errors");
}

}

[jasondavis]

hey it was actually my mistake 🙂 I had only updated the code in 1 section and it needed updated in 2 sections so sorry for the post but thanks for the reply and I can use that code in the future