Re: Anyone know why this won't return results?

At 17:45 -0400 6/7/02, Blaine Dinsmore wrote:

<html> <head> <title>Results Test</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body bgcolor="#FFFFFF" text="#000000"> <?php $server = "mdotlims"; $user = "httpuser"; $pass = "pass";

        $db = @mysql_connect($server,$user,$pass);

if (!$db) { echo( "<p>Unable to connect to the " . "database server at this time.</p>"); exit(); } if (! @mysql_select_db("lims_issues")) { echo("Unable to locate the issues " . "database at this time.</p>" ); exit(); } $result = @mysql_query("SELECT Notes FROM Bugs"); if (!$result) { echo("<p>Error performing query: " . mysql_error() . "</p>"); exit(); } While( $myrow = mysql_fetch_array($result) );{

You have a semicolon on the previous line, which terminates the while loop - a bit prematurely, I'd guess. :-)

echo ("<BR>" . $myrow["NOTES"]); } mysql_free_result($result); ?> </body> </html>