> $num_de_rows = mysql_num_rows ($r);
> this line <- if ( $num_de_rows > 0 ) { (i create some html
> tables here) }
> The error im getting is:
> Warning: Supplied argument is not a valid MySQL result resource in
> /home/passive-/public_html/pic_archive.php on line 172
I am not sure but have some ideas where to look.
Can you echo/print the value $num_de_rows? It could be that it is 'false' or
empty, and maybe php chokes on the comparison ? [ if (false>0) or (>0) ]
then test add in the if a test whether the $num_de_rows is false/empty.
Would it be an idea to set $num_de_rows to 0 before you start? Nahh...
wouldn't help.
Also try to print/echo the query and run the query on your database in
phpmyadmin and see if the resulting table is what you expected.
<obscure>
could it be that line 172 also contains a part of the html table printing?
i think the numbering of the $r array starts with index 0 so there is no
$r[1] if the number of rows is 1. Just $r[0].
</obscure>
hth,
Chris
--------------------------------------------------------------------
-- C.Hayes Droevendaal 35 6708 PB Wageningen the Netherlands --
--------------------------------------------------------------------
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
