For Programmers: Free Programming Magazines  


Home > Archive > PHP Language > January 2006 > Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource
Barrett Bonden

2005-12-07, 6:57 pm

I have a MYSQL/PHP install at home, and the same MYSQL table structure on a
hosting service (ipower) I get the following crash from the hosting site:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result
resource in /home/security/public_html/quotetest.php on line 17

which of course I don't get at home. Only difference is I'm running MYSQL
4.1.15 and PHP 4.0 - and the hosting service is on slightly different
versions - could this be the cause ? Or am I missing something else ?


Stefan Wallentowitz

2005-12-07, 6:57 pm

Am Wed, 07 Dec 2005 15:58:27 -0500 schrieb Barrett Bonden:

Hi!
> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
> result resource in /home/security/public_html/quotetest.php on line 17


Really be sure that authntication data is set correct and/or output of
mysql_connect is not surpressed (Did you use mysql_connect(...) or
die(mysql_error())?).

Bye,
Stefan

Dennis Ålund

2005-12-08, 7:57 am

Check database GRANTs also.

Make the same query in the mysql command prompt or some db-manager and
see what you get.

Connector5

2005-12-08, 6:59 pm

AND do a table repair if nothing else works.


"Barrett Bonden" <arthur@networks-cc.com> wrote in message
news:50Ilf.3788$Kf4.3072@fe08.lga...
> I have a MYSQL/PHP install at home, and the same MYSQL table structure on

a
> hosting service (ipower) I get the following crash from the hosting site:
>
> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL

result
> resource in /home/security/public_html/quotetest.php on line 17
>
> which of course I don't get at home. Only difference is I'm running MYSQL
> 4.1.15 and PHP 4.0 - and the hosting service is on slightly different
> versions - could this be the cause ? Or am I missing something else ?
>
>



Jim Michaels

2006-01-18, 6:57 pm

let's see the code.

"Barrett Bonden" <arthur@networks-cc.com> wrote in message
news:50Ilf.3788$Kf4.3072@fe08.lga...
>I have a MYSQL/PHP install at home, and the same MYSQL table structure on a
> hosting service (ipower) I get the following crash from the hosting site:
>
> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
> result
> resource in /home/security/public_html/quotetest.php on line 17
>
> which of course I don't get at home. Only difference is I'm running MYSQL
> 4.1.15 and PHP 4.0 - and the hosting service is on slightly different
> versions - could this be the cause ? Or am I missing something else ?
>
>



Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com