From: "Tyler Longren" <[EMAIL PROTECTED]>
> 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.
I can't see a reason why that wouldn't work. Is that your exact code, i.e.
you're not doing anything else between the mysql_query() call and the
mysql_affected_rows() call? What versions of PHP/MySQL are you using?
---John Holmes...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
