<?php
  require 'main.php';
  
  function displayList($connection, $query, $edit, $n) {
    if (!($result = @ mysql_query($query, $connection)))
      die;
    
    $edit = strtoupper($edit);
    
    echo $query;
    die;
    while ($row = @ mysql_fetch_array($result)) {
      $r = strtoupper($row["name"]);

      if (strpos($r, $edit) === false) {
      }   
      else
      {
        $row["numb"] = str_replace("#", "/", $row["numb"]);
        if ((($n == 1) || ($n == 3)) && ($row["what"] == 0)) {
?>
        <TABLE ID="vypisTable" border="1" cellpadding="0" cellspacing="0">
          <TR class="topVypis1">
          <TD class="leftVypisCell">
            Název:
          </TD>
          <TD class="rightVypisCell">       
<?
            echo $row["name"];
?>
          </TD>
          <TR>
          <TD class="leftVypisCell">
            Výrobce:
          </TD>
          <TD class="rightVypisCell">
<?
            echo $row["auth"];
?>
          </TD>
          <TR>
          <TD class="leftVypisCell">
            Číslo/Strana:
          </TD>
          <TD class="rightVypisCell">
<?
            echo $row["numb"];
?>
          </TD>
          <TR>
          <TD class="leftVypisCell">
            Návody:
          </TD>
          <TD class="rightVypisCell">
<?
            echo $row["tips"];
?>
          </TD>
          <TR>
          <TD class="bottomLeftVypisCell">
            CD/DVD:
          </TD>
          <TD class="bottomRightVypisCell">
<?
            echo $row["demo"];
?>
          </TD>
        </TABLE>
<?
        }
        else
        if ((($n == 2) || ($n == 3)) && ($row["what"] == 1)) {
?>
        <TABLE ID="vypisTable" border="1" cellpadding="0" cellspacing="0">
          <TR class="topVypis2">
          <TD class="leftVypisCell">
            Název:
          </TD>
          <TD class="rightVypisCell">       
<?
            echo $row["name"];
?>
          </TD>
          <TR>
          <TD class="bottomLeftVypisCell">
            Číslo/Strana:
          </TD>
          <TD class="bottomRightVypisCell">
<?
            echo $row["numb"];
?>
          </TD>
        </TABLE>
<?        
        }
      }
    }  
  }  
?>

    <TD ID="rightCell">
      <TABLE ID="rightTable">
      <TR>
      <TD>
        <FORM method="POST" action="online.php" name="onlineForm">
        <TABLE ID="onlineTable" border="1" cellpadding="0" cellspacing="0">
          <TR>
          <TD ID="onlineEdit" colspan="3">
              <INPUT TYPE="text" value="" name="edit" size="30">
              <INPUT TYPE="submit" value="Vyhledat" name="but">
          </TD>
          <TR>
          <TD class="bokLeft">
            &nbsp;
          </TD>
          <TD ID="onlineRadios">
            <INPUT TYPE="radio" value="1" name="google" checked>Hledat pouze hry&nbsp; &nbsp; &nbsp;
            <INPUT TYPE="radio" value="2" name="google">Pouze neherní články&nbsp; &nbsp; &nbsp;
            <INPUT TYPE="radio" value="3" name="google">Vypisovat vše
          </TD>
          <TD class="bokRight">
            č. 1-155
          </TD>
        </TABLE>         
        </FORM>
        <script type="text/javascript">
          document.onlineForm.edit.focus();
        </script>            
<?
            if (isset($edit) && (!empty($edit)))
            {
              if (!($connection = @ mysql_connect($hostname, $username, $password)))
                showerror();
   
              if (!mysql_select_db($databaseName, $connection))
                showerror();

              $query = "SELECT name, auth, tips, numb, demo, what FROM score order by name";

              displayList($connection, $query, $edit, $google);

              mysql_close($connection);
            }
?>
      </TD>
      </TABLE>
    </TD>
  </TABLE>
</BODY>
</HTML>
