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_array(): supplied argument is not a valid MySQL result resource

and my code is

Expand|Select|Wrap|Line Numbers

 
      <?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.

Quote:

Originally Posted by kalyanip14

Thanks for you reply.But resource are correct..

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:

Expand|Select|Wrap|Line Numbers

$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

Supplied argument is not a valid MySQL result resource.

re: Supplied argument is not a valid MySQL result resource.

re: Supplied argument is not a valid MySQL result resource.

re: Supplied argument is not a valid MySQL result resource.

re: Supplied argument is not a valid MySQL result resource.

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about