Hi,
I don't think mysql_affected_rows() is working like it should for me.
In the manual for mysql_affected_rows() it has this (Example 1):
/* this should return the correct numbers of deleted records */
mysql_query("DELETE FROM mytable WHERE id < 10");
printf("Records deleted: %d\n", mysql_affected_rows());
However, when I do this:
$delete_assignment = mysql_query("DELETE FROM consultingprojectassign
WHERE workerid='$assigned[$i]'");
printf("Records deleted: %d\n", mysql_affected_rows());
It always says "Records deleted: 0". Even though the record was,
indeed, deleted. I have an if statement also that says if
mysql_affected_rows() < "1", then print an error message. Well, since
it always returns 0, no matter what, the error is always shown, even
when the record is deleted.
As I understand it, if no WHERE clause is in the query, then it will
automatically return a 0. As you can see, my query above does have a
WHERE clause. Can anyone help me out?
Thanks!!!
Best Regards,
--
Tyler Longren
J.D. Web Services, L.C.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
