mysql_fetch_array(): supplied argument is not a valid MySQL result resource

•

What is DaniWeb IT Discussion Community?

You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 429,893 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,401 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Thread Tools Display Modes

Views: 325 | Replies: 2

Previous Post in Thread

Next Post in Thread

•

Join Date: Apr 2008

Posts: 3

Reputation: Doctoremote is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

Doctoremote Doctoremote is offline

Offline

Newbie Poster

mysql_fetch_array(): supplied argument is not a valid MySQL result resource

Apr 30th, 2008

This maybe an old chessnut to you old sweats but I am a newbie to this.. I getting this error:-
mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\wamp\www\dsg\Mytest.php on line 9
the database is called Camsdb
the table is called DBF
the fields of which there are three
1) refid
2)Datfd
3)Datfd2
the database connects but if fails on line 9

This is the code:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<?php
 $con = mysql_connect("192.168.10.6","trevor","trevor");
 if (!$con)
 {
  die('Could not connect: ' . mysql_error());
 }
  mysql_select_db("Camsdb", $con);
  $result = mysql_query("SELECT * FROM DBF");
  while($row = mysql_fetch_array($result));
  {
  echo $row['Datfd'] . " " . $row['Datfd2'];
  echo "<br />";
  }
  mysql_close($con);
 ?>
<?php
 $con = mysql_connect("192.168.10.6","trevor","trevor");
 if (!$con)
 {
  die('Could not connect: ' . mysql_error());
 }
  mysql_select_db("Camsdb", $con);
  $result = mysql_query("SELECT * FROM DBF");
  while($row = mysql_fetch_array($result));
  {
  echo $row['Datfd'] . " " . $row['Datfd2'];
  echo "<br />";
  }
  mysql_close($con);
 ?>