To reitterate what Jason said, this is assignment is invalid.
---
$cartquery = mysql_query("SELECT CartItemsID,Date FROM CartItems");
$cartnow = mysql_query($cartquery);
----
$cartnow will contain FALSE. And mysql_num_rows(false) will give the error
you are recieving.
-Keivn
----- Original Message -----
From: "Mike At Spy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 08, 2002 2:13 PM
Subject: [PHP] Weird, weird, weird!
>
> Anyone ever have the experience of working on a site, working with MySQL
and
> then having something almost inexplicable happen?
>
> I was working on a script, and had this weird event. A very simple script
> with this:
>
> mysql_connect("localhost","user","pass");
> mysql_select_db("dbname")
> or die("Query Connection Database failed");
> $old=date("z")-1;
> mysql_query("DELETE FROM Users WHERE Date < $old");
>
> $cartquery = mysql_query("SELECT CartItemsID,Date FROM CartItems")
> or die("Query failed");
> $cartnow = mysql_query($cartquery);
> $cr=0;
> $cartme = mysql_num_rows($cartnow); <<<<this is the line that is failing!
> while ($cr < $cartme){
> $cartrow=mysql_fetch_row($cartnow);
> $CII=$cartrow[0];
> $CDa=$cartrow[1];
> $pieces=explode(":",$CDa);
> $DCHK=$pieces[1];
> if ($DCHK < $old) {
> mysql_query("DELETE FROM CartItems WHERE CartItemsID = '$CII'");
> }
> }
>
> Started spitting this error at me:
>
> Warning: Supplied argument is not a valid MySQL result resource in (exact
> location snipped)
>
> This is the line containing mysql_num_rows that is getting this error.
>
> Someone please tell me I'm missing something obvious! Yes, the connects
to
> MySQL database are fine. I can run the query right in phpMyAdmin with no
> issues.
>
> If mysql_num_rows returns 0, or empty, it shouldn't be complaining, should
> it? It would just skip the loop, correct?
>
> Thanks,
>
> -Mike
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
