Anyone know why this won't return results?
| From: | Blaine Dinsmore | Date: | Fri, 07 Jun 2002 21:45:49 +0000 |
| Subject: | Anyone know why this won't return results? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19673@lists.php.net to get a copy of this message | ||
<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) );{
echo ("<BR>" . $myrow["NOTES"]);
}
mysql_free_result($result);
?>
</body>
</html>