displaying mysql record in php

slash75

I am running apache with mysql and php. I want to display a simple recordset on a php page. I am new to php and am using the code example here:

http://www.w3schools.com/php/php_mysql_select.asp

Here is the code with the fields I want to display.

<html>
<body>

<?php
$con = mysql_connect("localhost","john","1234");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("mydb", $con);

$result = mysql_query("SELECT * FROM users");

echo "<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>";while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['FName'] . "</td>";
  echo "<td>" . $row['LName'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
mysql_close($con);
?>


</body>
</html>

When I pull up the page it is blank? Is there something I am missing?

YAOMK

Have a look at mysql_fetch_array().

Try this:

while($row = mysql_fetch_array($result, MYSQL_ASSOC))

slash75

Thanks. I tried that, but it still just shows a blank page.

YAOMK

are the for the corresponding table/fields values in your database? Also check on the source of the printed html page (even if blank) and see what is there.

Try running this version of your script:

<html>
<body>

<?php
error_reporting(E_ALL);
$con = mysql_connect("localhost","john","1234");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("mydb", $con);

$result = mysql_query("SELECT * FROM users");

echo "<table border='1'>
<tr>
<th>Firstname</th>
<th>Lastname</th>
</tr>";
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
  {
  echo "<tr>";
  echo "<td>" . $row['FName'] . "</td>";
  echo "<td>" . $row['LName'] . "</td>";
  echo "</tr>";
  }
echo "</table>";
echo mysql_errno($con) . ": " . mysql_error($con) . "\n";
mysql_close($con);
?>


</body>
</html>

Post back any errors you may find.

PS: As is, your script should at the very least print the column names "Firstname" and "Lastname", if not, you may not have php installed or there could be a related configuration issue.

slash75

I tried this and it still displays a blank page.
I check the database name and fields and they are correct.

I did a simple test with the code below and it displays fine.

<html>
<body><?php
$d=date("D");
if ($d=="Fri")
  echo "Have a nice weekend!"; 
elseif ($d=="Sun")
  echo "Have a nice Sunday!"; 
else
  echo "Have a nice day!"; 
?></body>
</html>