mysql_fetch_row --> error! Help please!

[Stefan van Roosmalen]

Hi there,

I am using some example PHP code to build a counter for a page on my
webserver.
When going to that page, I will see the following error message:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result
resource in C:\Program Files\Apache Group\Apache2\htdocs\test\test.php on
line 33

And line33 shows as follows:

for ($count = 1; $row = mysql_fetch_row($result); ++$count)

What did I do wrong here?

gr.,
Stefan.

[Stefan Hegenbart]

Stefan van Roosmalen wrote:

Hi there,

I am using some example PHP code to build a counter for a page on my
webserver.
When going to that page, I will see the following error message:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result
resource in C:\Program Files\Apache Group\Apache2\htdocs\test\test.php on
line 33

And line33 shows as follows:

for ($count = 1; $row = mysql_fetch_row($result); ++$count)

What did I do wrong here?

gr.,
Stefan.

hi there,

add between your for-loop and your query execution (mysql_query()) a
line like:

print(mysql_error());

the given error message assumes that something went wrong with your
database query. it did not return a result thus not being valid for
mysql_fetch_row.

regards,
stefan ;-)

--
"The goal of Computer Science is to build something that will last at
least until we've finished building it." -- unknown

[Alvaro G. Vicario]

*** Stefan van Roosmalen escribió/wrote (Sun, 12 Sep 2004 12:09:42 +0200):

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result
resource in C:\Program Files\Apache Group\Apache2\htdocs\test\test.php on
line 33

And line33 shows as follows:

for ($count = 1; $row = mysql_fetch_row($result); ++$count)

What did I do wrong here?

You apparently don't do error checking in a previous mysql_query().
There're many ways, one of them is:

$result=@mysql_query($query)
or die(mysql_error());

--
-+ Álvaro G. Vicario - Burgos, Spain
+- http://www.demogracia.com (la web de humor barnizada para la intemperie)
++ Las dudas informáticas recibidas por correo irán directas a la papelera
-+ I'm not a free help desk, please don't e-mail me your questions
--

[Janwillem Borleffs]

Stefan van Roosmalen wrote:

Hi there,

STOP MULTIPOSTING! (same message in alt.php)
JW

[Stefan van Roosmalen]

It's working now.

I was not using the right username/password, that's why my first SQL
statement went wrong!

Thank you all.

gr.,
Stefan.

"Stefan van Roosmalen" <ro******@planet.nl> wrote in message
news:ci**********@reader13.wxs.nl...

Hi there,

I am using some example PHP code to build a counter for a page on my
webserver.
When going to that page, I will see the following error message:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result
resource in C:\Program Files\Apache Group\Apache2\htdocs\test\test.php on
line 33

And line33 shows as follows:

for ($count = 1; $row = mysql_fetch_row($result); ++$count)

What did I do wrong here?

gr.,
Stefan.