$mysql_fetch_array help

danville

When I run this script it connects to the db ok and seems to fetch, but is not displaying correctly. Any ideas?
Here is the source that I get after running code. There is currently two records in the database.
<HTML>
<body>
<table border=1>
<tr><td>Name:</td><td>Email:</td></tr>
<tr><td></td><td><a href="mailto:"></a></td></tr>
<tr><td></td><td><a href="mailto:"></a></td></tr>
</table>
<body>
</HTML>

Code:

<?php
$db = mysql_connect("host", "user", "pass");
mysql_select_db("test",$db);
$result = mysql_query("SELECT * FROM email", $db);
if ($myrow = mysql_fetch_array($result)) {
echo "<table border=1>\n";
echo "<tr><td>Name:</td><td>Email:</td></tr>\n";
do {
printf("<tr><td>%s</td><td><a href=\"mailto:%s\">%s</a></td></tr>\n", $myrow["name"], $myrow["email"], $myrow["email"]);
} while ($myrow = mysql_fetch_array($result));
echo "</table>\n";
} else {
echo "Sorry no records were found!";
}
?>

rIkLuNd

Try this:

<?php
$db = mysql_connect("host", "user", "pass");
mysql_select_db("test",$db);
$result = mysql_query("SELECT * FROM email", $db);
if (mysql_num_rows($result) > 0)
{
  echo "<table border=1>\n";
  echo "<tr><td>Name:</td><td>Email:</td></tr>\n";
  while ($myrow = mysql_fetch_array($result,1))
  {
    printf("<tr><td>%s</td><td><a href=\"mailto:%s\">%s</a></td></tr>\n", 
    $myrow["name"], $myrow["email"], $myrow["email"]);
  }
  echo "</table>\n";
}
else
{
  echo "Sorry no records were found!";
}
?>

danville

Im getting the exact same source.

ahundiak

I pasted your printf into another piece of code and it seemed to work. Can you post the complete php file?

danville

That is the complete php code at the top of the thread.

ahundiak

Where did the HTML and body tags come from?

The only thing I can see is if you have the column names wrong. You might try a
print_r($myrow) just to confirm that data you have.

It's barely possible that the ,1 in mysql_fetch_array is messing you up. You might try replacing it with MYSQL_ASSOC though on my system MYSQL_ASSOC does equal 1.

danville

Sorry the HTML and BODY tags are in there as well.

<HTML>
<body>
<?php
$db = mysql_connect("host", "user", "pass");
mysql_select_db("test",$db);
$result = mysql_query("SELECT * FROM email", $db);
if ($myrow = mysql_fetch_array($result)) {
echo "<table border=1>\n";
echo "<tr><td>Name:</td><td>Email:</td></tr>\n";
do {
printf("<tr><td>%s</td><td><a href=\"mailto:%s\">%s</a></td></tr>\n", $myrow["name"], $myrow["email"], $myrow["email"]);
} while ($myrow = mysql_fetch_array($result));
echo "</table>\n";
} else {
echo "Sorry no records were found!";
}
?>
</body>
</HTML>