mysql_fetch_array() expects parameter 1 to be resource, string...line 39

[DVigneault]

Hey, all.  I'm new to php/mysql.

 

I'm getting the warning:

mysql_fetch_array() expects parameter 1 to be resource, string...line 39

 

with reference to the mysql_fetch_array function in the following code:

 

mysql_select_db("calculators", $con);

$query = "SELECT * FROM calculator WHERE Abbreviation = '" . $_GET['abbreviation'] . "'";

$result = mysql_query($query, $con);

while($row = mysql_fetch_array($result)) {
//some code...
  }

 

 

 

The code runs fine, but I'd like to know why I'm getting the warning.  I've looked at similar post on this forum and other forums and can't quite get a straight answer.

 

Thanks a bunch,

 

Davis

[trq]

You haven't checked your query succeeds or returned any results.

 

$query = "SELECT * FROM calculator WHERE Abbreviation = '" . $_GET['abbreviation'] . "'";
if ($result = mysql_query($query, $con)) {
  if (mysql_num_rows($result)) {
    while($row = mysql_fetch_array($result)) {
      //some code...
    }
  } else {
    // no results found
  }
} else {
  // query failed
}

[DVigneault]

Thanks, that did the trick!  Happy new years :-)