PHP fórum

Zdravim, mam taky problem so zobrazovanimm dat z drop-down listu. Robim projekt, kde mam php stranku na hladanie uzivatelov, kde si najdem pozdovaneho uzivatela. potom na toho hraca kliknem a zobrazia sa mi vsetky jeho vysledky. Avsak, ak chcem iba vysledky za urcite obdobie,ktore osetrujem pomocou drop-down listu tak je problem, aby si stranka zapamatovala ‚id‘ daneho uzivatela.Vie mi niekto pomoct, ako to osetrit? Dakujem.

Tu je moj kod:

<form method="POST" action="vysledkyNew.php?id={$_GET['id']}">
  <table cellspacing="20">
  <tr>
  <th>Den</th>
  <th>Mesiac</th>
  <th>Rok</th>
  <th>Den</th>
  <th>Mesiac</th>
  <th>Rok</th>
  </tr>
  <tr><td>OD</td>
    <td>

<select name="denOD">+
<?php for ($d = 1; $d <= 31; $d++) { ?>
        <option value="<?php echo $d; ?>"><?php echo $d; ?></option>
<?php } ?>
</select></td>
<td><select name="mesiacOD">
<?php for ($m = 1; $m <= 12; $m++) { ?>
        <option value="<?php echo $m; ?>"><?php echo $m; ?></option>
<?php } ?>
</select></td>
<td><select name="rokOD">
<?php for ($r = 1990; $r <= 2009 ; $r++) { ?>
        <option value="<?php echo $r; ?>"><?php echo $r; ?></option>
<?php } ?>
</select></td>
<td>DO</td>
<td><select name="denDO">
<?php for ($d = 1; $d <= 31; $d++) { ?>
        <option value="<?php echo $d; ?>"><?php echo $d; ?></option>
<?php } ?>
</select></td>
<td><select name="mesiacDO">
<?php for ($m = 1; $m <= 12; $m++) { ?>
        <option value="<?php echo $m; ?>"><?php echo $m; ?></option>
<?php } ?>
</select></td>
<td><select name="rokDO">
<?php for ($r = 1990; $r <= 2009 ; $r++) { ?>
        <option value="<?php echo $r; ?>"><?php echo $r; ?></option>
<?php } ?></select></td>
<td><input type="submit" value="potvrdit" name="submit" /></td>

</tr>
</table>
</form>
        <hr />
  <div class="main">

<?php
if (isset($_POST['submit'])){
                $premenna=($_GET["id"]) * 1;
                $denOD=$_POST['denOD'];
                $mesiacOD=$_POST['mesiacOD'];
                $rokOD=$_POST['rokOD'];
                $denDO=$_POST['denDO'];
                $mesiacDO=$_POST['mesiacDO'];
                $rokDO=$_POST['rokDO'];
                $OD=$denOD.$mesiacOD.$rokOD;
                $DO=$denDO.$mesiacDO.$rokDO;
                $guery ="SELECT DISTINCT DATE_FORMAT(res_time, '%d.%m.%Y') AS res_time, exc_excercise_name, res_result FROM res INNER JOIN exc ON res_exc_id=exc_id WHERE res_time >= $OD AND res_time <=                                                $DO AND res_sub_id=1 AND res_usr_id=$premenna ORDER BY res_time DESC";
                $result = mysql_fetch_row($guery);
                if($result){
                echo "<table cellspacing='20'>",
                "<tr>",
                "<th>","</th>",
                "<th>","</th>",
                "<th>",
    $sum_good,"</th>",
                "<th>",$sum_bad,"</th>",
                "<th>",$fruitfull,"</th>",
                "</tr>";
    while (list($res_time,$exc_excercise_name,$res_result) = mysql_fetch_row($result)) {
      echo "<tr>",
      "<td class='time'>",
      $res_time,"</td>",
      "</tr>","<tr>",
      "<td>","</td>",
      "<td class='font'>",
      $exc_excercise_name,"</td>",
      "<td>","</td>",
      "<td>","</td>",
      "<td class='result'>",
      $res_result,"%","</td>",
      "</tr>";
    }
    echo "</table>";
  }
  else {
        print $error1;
  }
  }

Editoval raul66 (24. 6. 2009 11:15)