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>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
