Hi Cpt,
That's not the exact code. The exact code is below. Multiple workers
are being selected from a MULTIPLE <select> form field. I just use a
while loop do go through the selected ones to delete them individually.
PHP Version: 4.3.4
MySQL Version: 4.0.17
$i="0";
while ($i <= "$selected") {
$delete_assignment = mysql_query("DELETE FROM webprojectassign WHERE
workerid='$assigned[$i]'");
$i++;
}
if (mysql_affected_rows($delete_assignment) < "1") {
$tpl->newBlock('message');
$tpl->assign("message","<b>ERROR:</b> There was an error deleting those
workers from the project.");
}
else {
$tpl->newBlock('message');
$tpl->assign("message","The workers have been deleted from the
project.");
}
If you (or anyone else) know of another way I should be doing this,
please let me know. I'm open to any suggestions.
Best Regards,
--
Tyler Longren
J.D. Web Services, L.C.
On Tue, 2004-01-06 at 15:14, CPT John W. Holmes wrote:
> 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
