If you do a select on that table, before retrieving the results (
while($result_data=mysql_fetch_array($query)) ) verify that the result has
rows
ie
if(mysql_num_rows($query)>0)
while($result_data=mysql_fetch_array($query))
{
do something with the results
}
else
NO RESULTS.....
"Rich Gray" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Can you post some code to look at?
>
> -----Original Message-----
> From: M.B. [mailto:[EMAIL PROTECTED]]
> Sent: 11 September 2002 20:32
> To: [EMAIL PROTECTED]
> Subject: [PHP-WIN] Error after a while???
>
>
> Hi, I have a database and a site which has members and so on......
> but now I have service (also for a long time) http://www.wjp.cjb.net
> a guestbook service.
> But yesterday somebody mailt me to say that this error was on his
> guestbooksite:
>
> Warning: mysql_num_rows(): supplied argument is not a valid MySQL result
> resource in /home/k/l/klaassen/public_html/WJP/include/gastenboek.php on
> line 9
>
> Warning: mysql_fetch_object(): supplied argument is not a valid MySQL
result
> resource in /home/k/l/klaassen/public_html/WJP/include/gastenboek.php on
> line 28
>
>
> I checked his table and found out that the table is empty.
> What could there be wrong with this line of code if a table is empty?
>
>
>
> And what can I do about it.
> It never accurred before and we tested this service a lot before we
started
> using it, and then there wasn''t any problem at all when a table was
empty.
> (PS all the fields in the table have the option that they are allowed to
be
> empty.)
>
> M.B.
>
>
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
