Help Guestbook

<?php if (isset($_GET['addcomment'])): // User wants to add a comment
?>

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<input type="text" name="name" value="name">
<label>Type your comment here:<br />
<textarea name="coment" rows="10" cols="40">
</textarea></label><br />
<input type="submit" value="SUBMIT" />
</form>

<?php else: // Default page display

  // Connect to the database server
  $dbcnx = @mysql_connect('localhost', '********', '********');
  if (!$dbcnx) {
    exit('<p>Unable to connect to the ' .
        'database server at this time.</p>');
  }

  // Select the database
  if (!@mysql_select_db('eimblog_111mb_com_db')) {
    exit('<p>Unable to locate the ' .
        'database at this time.</p>');
  }

  // If a comment has been submitted,
  // add it to the database.
  if (isset($_POST['coment'])) {
    $coment = $_POST['coment'];
    $name = $_POST['name'];
    $sql = "INSERT INTO about SET
        coment='$coment',
        name='$name',
        postdate=CURDATE()";
    if (@mysql_query($sql)) {
      echo '<p>Your comment has been added.</p>';
    } else {
      echo '<p>Error adding submitted comment: ' .
          mysql_error() . '</p>';
    }
  }

  echo '<p>Here are all the comments in our database:</p>';

  // Request the text of all the comments
  $result = @mysql_query('SELECT coment FROM about');
  if (!$result) {
    exit('<p>Error performing query: ' .
        mysql_error() . '</p>');
  }

$name = @mysql_query('SELECT name FROM about');
  if (!$name) {
    exit('<p>Error performing query: ' .
        mysql_error() . '</p>');
  }

  // Display the text of each comment in a paragraph
   While(
    $row = mysql_fetch_array($result);
    $row2 = mysql_fetch_array($name);){
    print("<b> .$row2['name']  $row['coment'] . </b>");
  }

  // When clicked, this link will load this page
  // with the joke submission form displayed.
  echo '<p><a href="' . $_SERVER['PHP_SELF'] .
      '?addcomment=1">Add your comment</a></p>';