Member Avatar for Doctoremote

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:

<?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);
 ?>

Can someone help me as I am a real nubie to this connection lark

Regards Trevor

  • 2 Contributors
  • 2 Replies
  • 135 Views
  • 18 Hours Discussion Span
  • Latest Post Latest Post by Doctoremote

Recommended Answers

All 2 Replies

Member Avatar for phper

You have closed the while loop.

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

Notice the ; on the end. Remove this and you query should run.

Regards,
Alex.

Member Avatar for Doctoremote

Thanks m8 for that now running sweet :-)
I have found that when ever you get this error it is MYSQL shouting that something is wrong with one of three things
1) The name of your database is wrong
2) The syntax is wrong
3) Variable not set correctly

Thanks for all your help

I have since rewritten the code so that displays properly in a nice box arrangement

<?php
$con = mysql_connect("connection","username","passord");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
  print "Connected to MySQL<br>";

mysql_select_db("database name", $con);
  $result = mysql_query("SELECT * FROM DSG ORDER BY yourfield");

 echo "<table border='1'>
<tr>
<th>yourfield</th>
<th>yourfield2</th>
<th>yourfield3</th>
</tr>";while($row = mysql_fetch_array($result))
   {
  echo "<tr>";
  echo "<td>" . $row['yourfield'] . "</td>";
  echo "<td>" . $row['yourfield2'] . "</td>";
  echo "<td>" . $row['yourfield3'] . "</td>";
  echo "</tr>";
  }
echo "</table>";


print "code by doctoremote<br>";

  mysql_close($con);
?>

this is free to look at to get going for all those like me who were having problems getting started it save so much time when you do not have to reinvent the wheel.....

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.