Code will not print to browser

[endlyss]

Why does the following code not print to the browser? I am trying to return a query from a database immediately upon the loading of a webpage.

The following only brings up a blank page.

Thank you for your help.
.....................

$test = "";

if ($test == ""){

{
$con = mysql_connect("","","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

}

mysql_select_db("", $con);

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

while($row = mysql_fetch_array($result))
{
echo $row['FirstName'] . " " . $row['LastName'];
echo "<br />";
}

mysql_close($con);
}
.....................

[HalfaBee]

Have you done any debugging?

Check that $result is a resource, do a print_r( $row ) in the while loop.

[endlyss]

Thanks HalfaBee

I've done as much debugging as I could think of.

print_r( $row ) results the data I am looking for so it is there but not showing up.

[HalfaBee]

The array keys are case SenSitiVe

[NogDog]

Have you spelled the (case-sensitive) array indexes correctly for the $row elements in your echo statement? Also, if there's other HTML on the page, try a "View Source" in the browser to see if the output is there, but maybe got swallowed up inside of some mal-formed HTML tag or something.

Lastly, for debugging you may want to ensure all errors/warnings are being output, in order to see if PHP itself has anything "interesting" to tell you. Just add the following to the start of the PHP code:

<?php
ini_set('display_errors', 1);  // set to zero for production version
error_reporting(E_ALL);

[endlyss]

Thank you very, very much.