HELP!! call, email, come to my house!!!

kappaluppa

I am new to PHP and have undertaken a large task! oy vey!!!

I am getting an error on my page and I can't see why. This is the error message:

Warning: Supplied argument is not a valid MySQL result resource in /webusers/usera/gop/coloradosenate.com/www/db/stitchdot.php3 on line 101

This is the line that is supposed to have the error:

while($row = mysql_fetch_array($result)) {

I don't see anything wrong with it, but like i said, i am new to this.

this is the website address i am using:

http://www.coloradosenate.com/db/stitchdot.php3

I'm trying to use the code from PHP Essentials to do this.

this is the link to the code:
http://www.phptr.com/essential/php/code_html/chapter8/stitchdot.php3.html

ANY HELP WOULD BE GREAT!!!
PLEAS ICQ ME AT 175184 THANKS!!!!

Anon

The problem is that your line that produces the $result variable is having a problem. Either you don't have permission to access the database/table, or your query has a problem with it that is causeing MySQL to error thus not returning a valid $result.

You should look at some of the articles here about accessing a database and see the error handeling that they incorporate.

Post the code that generates your SQL statement and the line where you set $result and I'm sure someone will show you how to trap it's errors and exit gracefully.

Anon

Instead of all those other contact methods, how about a reply here? That way others get to follow the conversation!

Anyway, the problem is not in the code you show, but rather in the query itself: when you issue the query, be sure to check for success and print a detailed error message:

if (! ($result = mysql_query( $query )))
  {
  echo "Oops: can't execute<br>$query<br>";
  echo mysql_error() . '<br>";
  }
else
  {
  // all is well, go ahead and retrieve the data...

kappaluppa

Your suggestions helped & fixed!

The database wasn't connecting.

amcgrath

I didnt't give you an answer, but can I still come over your house? 😉

vsego

I bet Kathy would be happy to have you wash her windows (not the capital "w"!), clean her house, do the ironing,... whatever needs to be done. And the one who's usually doing it in her house would be grateful to you. >-)