ql_connect("localhost", "root", "abc123")  
              or die("Could not connect<br>");

      $select = mysql_select_db ("guestbook");
      if (!$select) {
          echo "<font size=2 color=red>";
          echo "데이타베이스 선택시 오류가 발생하였습니다.";
          echo "</font>";
          exit;
      }

      $query = "select * from guestbook where idxnum = $idxnum";
      $result = mysql_query($query);
      if (!$result) {
          echo "<font size=2 color=red>";
          echo "질의 수행시 오류가 발생하였습니다.";
          echo "</font>";
          exit;
      }

      $count = 0;
      $rowcnt = mysql_num_rows($result);
      if ($rowcnt!= 1) {
          echo "Error<br>";
          exit;
      }

      $row = mysql_fetch_row($result);

      $view = intval($row[9]);
      $view++;

      $updatesql = "update guestbook set view = $view where idxnum = $idxnum";
      $result = mysql_query($updatesql);
      if (!$result) {
          echo "<font size=2 color=red>";
          echo "update문 수행시 오류가 발생하였습니다.";
          echo "</font>";
          exit;
      }

      echo "
      <center>
      <font size=4 color=blue><b>
      방명록 글내용 보기
      </b></font>
      <br> <br>

      <table border=1 width=500 cellspacing=0 cellpadding=2>
      <tr>
          <td align=center width=100>
          <font size=2 color=teal>
          글번호
          </font>
          </td>

          <td>
          <font size=2 color=teal>
          $row[0]
          </font>
          </td>
      </tr>

      <tr>
          <td align=center width=100>
          <font size=2 color=teal>
          작성자
          </font>
          </td>

          <td>
          <font size=2 color=teal>
          $row[1]
          </font>
          </td>
      </tr>

      <tr>
          <td align=center width=100>
          <font size=2 color=teal>
          IP 주소
          </font>
          </td>

          <td>
          <font size=2 color=teal>
           $row[5]
          </font>
          </td>
      </tr>


 
      <tr>
          <td align=center width=100>
          <font size=2 color=teal>
          작성 날짜/시간
          </font>
          </td>

          <td>
          <font size=2 color=teal>
          $row[4]
          </font>
          </td>
      </tr>

  

      <tr>
          <td valign=top align=center width=100>
          <font size=2 color=teal>
          글내용
          </font>
          </td>

          <td>
          <font size=2 color=teal>
          ".ereg_replace("\n", "<br>", $row[3])."
          </font>
          </td>
      </tr>
      </table>

      <br>
      <font size=2 color=teal>
      <a href=update.html?idxnum=$idxnum>수정하기</a>
      &nbsp;
      <a href=delete.html?idxnum=$idxnum>삭제하기</a>
      &nbsp;
      <a href=list.html>리스트로</a>
      &nbsp;
      <a href=insertform.html>글쓰기</a>

      </font>
      ";
      mysql_close($dbconn);
      ?>