Hi David, Thanks for your help. I've taken out the @ character, and added the error-trapping code to my file.
The results: When I run the file, nothing untoward is reported, and I end up with a blank screen in IE / Moxilla Firebird / Opera. There are no errors reported. In the Apache error log, there are no error or movement messages reported for this operation. In the Apache Access Log the following is reported: "127.0.0.1 - - [12/Dec/2004:13:23:19 +0000] "GET / HTTP/1.1" 200 1494 127.0.0.1 - - [12/Dec/2004:13:23:20 +0000] "GET /apache_pb.gif HTTP/1.1" 304 - 127.0.0.1 - - [12/Dec/2004:13:23:32 +0000] "GET /mysqlconnectcomplete.php HTTP/1.1" 200 -" I have the usual permissions on the database server which is accessible via the command prompt with no problem. I have the MyODBC driver installed and configured just in case PHP is looking for it for some strange reason. I've pasted the code below this message: Used Code:- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> <html xmlns="http://www.w3.org/1999/xhtml";> <head> <title>Our List of Jokes</title> <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> </head> <body> <?php // Connect to the database server $dbcnx = mysql_connect('localhost', 'root', 'MyPassWord'); if (!$dbcnx) { echo '<p>Unable to connect to the ' . 'database server at this time.</p>' ); echo mysql_error(); exit(); } // Select the jokes database if ([EMAIL PROTECTED]('ijdb')) { echo mysql_error(); exit('<p>Unable to locate the joke ' . 'database at this time.</p>'); } ?> <p>Here are all the jokes in our database:</p> <blockquote> <?php // Request the text of all the jokes $result = mysql_query('SELECT joketext FROM joke'); if (!$result) { exit('<p>Error performing query: ' . mysql_error() . '</p>'); } // Display the text of each joke in a paragraph while ($row = mysql_fetch_array($result)) { echo '<p>' . $row['joketext'] . '</p>'; } ?> </blockquote> </body> </html> ----- Original Message ----- From: "David Robley" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, December 12, 2004 5:25 AM Subject: [PHP] Re: Sorry forgot to include the code for my last message - Mike Francis > On Sun, 12 Dec 2004 07:03, Mike Francis wrote: > > > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" > > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd";> > > <html xmlns="http://www.w3.org/1999/xhtml";> > > <head> > > <title>Our List of Jokes</title> > > <meta http-equiv="content-type" > > content="text/html; charset=iso-8859-1" /> > > </head> > > <body> > > <?php > > // Connect to the database server > > $dbcnx = @mysql_connect('localhost', 'root', 'MyPassword'); > > if (!$dbcnx) { > > echo '<p>Unable to connect to the ' . > > 'database server at this time.</p>' ); > > Note that using the @ in front of the connect suppresses any error messsages > that may be returned from the connect; I would get rid of that. Then add > here: > > echo mysql_error(); > > exit(); > > } > > // Select the jokes database > > if ([EMAIL PROTECTED]('ijdb')) { > > And use mysql_error() here too. > > exit('<p>Unable to locate the joke ' . > > 'database at this time.</p>'); > > } > > ?> > > mysql_error() will return a useful error message. > > -- > David Robley > > Backups? We doan *NEED* no steenking baX%^~,VbKx NO CARRIER > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
