Supplied argument is not a valid MySQL result resource.

[kalyanip14]

Hi I am new to Php.I am trying to read My sql database data from table to php.

I am getting this warning

Warning: mysql_fetch_arr ay(): supplied argument is not a valid MySQL result resource

and my code is

      <?php
 
      $con = mysql_connect("localhost","sandman","sandcastle");
 
      if (!$con)
 
      {
 
      die('Could not connect: ' . mysql_error());
 
      }
 
      print "Connected to MySQL<br>";
 
 
 
      mysql_select_db("sandbox", $con);
 
 
 
      $result = mysql_query("SELECT parcel,location from accessor");
 
 
 
      echo "<table border='1'>
 
      <tr>
 
      <th>Parcel</th>
 
      <th>Location</th>
 
        </tr>";
while($row = mysql_fetch_array($result))
 
      {
 
      echo "<tr>";
 
      echo "<td>" . $row['parcel'] . "</td>";
 
      echo "<td>" . $row['location'] . "</td>";
 
 
 
      echo "</tr>";
 
      }
 
 
      echo "</table>";
 
 
 
      mysql_close($con);
 
      ?>
 

plz let me know where I am doing wrong

[Dormilich]

I guess the query failed and thus returned false (which is not a valid resource).

[kalyanip14]

Thanks for you reply.But resource are correct..

[Atli]

Hi.

@kalyanip14
Apparently, they are not.
PHP warnings do not lie, and this one is telling you that the resource is not valid.

You should always make sure of this yourself before you try to use the resource returned by a function.
The usual way to do that with MySQL queries is to do:

$result = mysql_query("your query here") or die(mysql_error());

This prints the error you SQL is generating and stops the code from executing any further, if the SQL query fails.
If the SQL query is successful, it moves on the the next line of code.

If you want to handle this more gracefully, you can simply check the $result of the query before it is used. If it is FALSE, your query failed.

[kalyanip14]

I sloved it thanks for your help