MySQL error

data switch · December 3rd, 2003, 02:01 PM

I just started learning MySQL and PHP. The book gave me a file to use to test to see if MySQL and PHP were communicating properly. When I load that file, I get an error. The error is on the image I have attached. Here is the code for it:

PHP Code:

 
<html>

<head>

<title>Test MySQL</title>

<body>

<!-- mysql_up.php -->

<?php

$host="matts-comp.attbi.com";

$user="matt";

$password="*******";

 
mysql_connect($host,$user,$password);

$sql="show status";

$result = mysql_query($sql);

if ($result == 0)

   echo("<b>Error " . mysql_errno() . ": " . mysql_error() . "</b>");

elseif (mysql_num_rows($result) == 0)

   echo("<b>Query executed successfully!</b>");

else

{

?>

<!-- Table that displays the results -->

<table border="1">

  <tr><td><b>Variable_name</b></td><td><b>Value</b></td></tr>

  <?php

    for ($i = 0; $i < mysql_num_rows($result); $i++) {

      echo("<TR>");

      $row_array = mysql_fetch_row($result);

      for ($j = 0; $j < mysql_num_fields($result); $j++) {

        echo("<TD>" . $row_array[$j] . "</td>");

        }

        echo("</tr>");

    }

  ?>

</table>

<?php } ?>

</body>

</html>

My password is not actually like that, I just replaced it with the asterisks.

So anyone have an idea what could be wrong?

davidamarkley · December 3rd, 2003, 06:08 PM

It works perfectly for me on my mySQL/PHP/Apache web server.

First thing to check is your username and password, as well as your domain name.

Make sure all are EXACTLY correct.

It almost looks like your screenshot is showing a syntax error on the page, not a mysql error.

What I would do is to copy-and-paste the EXACT info you posted, and create a new .php file named something like 'test.php' (without the quotes)

Then, just open up IE/Mozilla/Netscape/Opera and shoot to that page.

HTH,

David