Выпадающий список (Страница 7 из 41)

if($row2["ostatok"] > 0) {
// Выводить.
} else {
// Не выводить.
}

<?php
echo '<form method="post" action="">';
$auto = "<select id='id_auto' name='nazv_auto' size='1' onchange=\"this.form.submit();\">;
        <option value='vse'>Производитель</option>";
          $query = mysql_query("SELECT * FROM auto ORDER BY id_auto");
              $result = mysql_fetch_array($query);
                do
                {
                    $auto .= "<option value='".$result['id_auto']."'";
                    if (!empty($_POST['nazv_auto']) && $_POST['nazv_auto'] == $result['id_auto']) {
                        $auto .= ' selected="selected"';
                    }
                    $auto .= ">".$result['nazv_auto']."</option>";
                }
               while($result = mysql_fetch_array($query));
$auto.= "</select>";
echo $auto."";
if (!empty($_POST['nazv_auto'])) {
     
     $model = "-<select id='id_model' name='nazv_model' size='1' onchange=\"this.form.submit();\">;
                <option value='vse'>Модель</option>";
      $query = mysql_query("SELECT * FROM automodel
WHERE id_auto = '" . addslashes($_POST['nazv_auto']) . "' ORDER BY id_model");
                $result = mysql_fetch_array($query);
                 do
                {
                    $model .= "<option value='".$result['id_model']."'";
                    if (!empty($_POST['nazv_model']) && $_POST['nazv_model'] == $result['id_model']) {
                        $model .= ' selected="selected"';
                    }
                    $model .= ">".$result['nazv_model']."</option>";
                }
                while($result = mysql_fetch_array($query));
$model .= "</select>";
echo $model.""."";
}
if (!empty($_POST['nazv_auto']) && !empty($_POST['nazv_model'])) {
    
$year = "-<select id='id_year' name='nazv_year' size='1'  onchange=\"this.form.submit();\">;
                <option value='vse'>Год</option>";
                $query = mysql_query("SELECT * FROM year
WHERE id_model='" . addslashes($_POST['nazv_model']) . "'    ORDER BY id_year");
                $result = mysql_fetch_array($query);
                 do
                {
                    $year .= "<option value='".$result['id_year']."'";
                    if (!empty($_POST['nazv_year']) && $_POST['nazv_year'] == $result['id_year']) {
                        $year .= ' selected="selected"';
                    }
                    $year .= ">".$result['nazv_year']."</option>";
                }
                while($result = mysql_fetch_array($query));
$year .= "</select>";
echo $year.""."";
if (!empty($_POST['nazv_auto']) && !empty($_POST['nazv_model']) && !empty($_POST['nazv_year'])); {
}
$modifikation = "-<select id='id_mod' name='mod' size='1' >;
                <option value='vse'>Модификация</option>";
                $query = mysql_query("SELECT * FROM modif
WHERE id_year='" . addslashes($_POST['nazv_year']) . "' ORDER BY id_mod");
                $result = mysql_fetch_array($query);
                do
                {
                    $modifikation .= "<option value='".$result['id_mod']."'";
                    if (!empty($_POST['id_mod']) && $_POST['id_mod'] == $result['id_mod']) {
                        $modifikation .= ' selected="selected"';
                    }
                    $modifikation .= ">".$result['mod']."</option>";
                }
                while($result = mysql_fetch_array($query));
$modifikation .= "</select>";
echo $modifikation."<br>"."<br>";
}
if (!empty($_POST['nazv_auto']) && !empty($_POST['nazv_model'])  && !empty($_POST['nazv_year'])
&& !empty($_POST['mod']) && !empty($_POST['sezon'])); {
}

echo ' зима <input type="radio" name="sezon" value="зимние" />';
echo ' лето <input type="radio" name="sezon" value="летние"  checked/>';
echo ' <input type="submit" value="Подобрать" />';                         
                          
echo '<p><table border = "1">
          <tr>
          <th>модель</th>
          <th>диаметр</th>
          <th>ширина</th>
          <th>профиль</th>
          </tr>';
          $result = mysql_query ("SELECT * 
FROM proba
WHERE auto= '" . addslashes($_POST['mod']) . "' and sezon = '" . addslashes($_POST['sezon']) . "'  ",$db);





while ($myrow = mysql_fetch_array ($result)){
   
    $model = $myrow["model"];
    $sezon = $myrow["sezon"];
    $shirina = $myrow["shirina"];
    $profil = $myrow["profil"];
    $indnag = $myrow["indnag"];
    $indskor = $myrow["indskor"];
    $ostatok = $myrow["ostatok"];
    $cena = $myrow["cena"];
    
    echo "<tr>";
    echo "<td>$model</td>";
    echo "<td>$sezo</td>";
    echo "<td>$shirina</td>";
    echo "<td>$profil</td>";
    echo "<td>$indnag</td>";
    echo "<td>$indskor</td>";
    echo "<td>$ostatok</td>";
    echo "<td>$cena</td>";
    echo "</tr>";
    echo "<a href='view_form.php?id=%s'>заказать</a>";
    

    }




echo '</table>';

echo "</form>";

 ?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1251">
<title>Untitled Document</title>
</head>

<body>
<?php include("blocks/conect.php");

$result2 = mysql_query("select * from model ",$db);

while ($row2 = mysql_fetch_array($result2)) {
    if ($row2["ostatok"] > 0) {
        printf ("<table width=900' border='1'>

          <tr>
                   
            <td width='100'>%s</td>
            <td width='100'>%s</td>
            <td width='100'>%s</td>
            <td width='150'>%s</td>
            <td width='150'>%s</td>
            <td width='100'>%s</td>
            <td width='100'>%s</td>
           <td width='100'>Всего%s</td>
             <td > <a href='view_form.php?id=%s'>заказать</a></td>
          </tr>
                     </table>", $row2["shirina"], $row2["profil"], $row2["diametr"], $row2["indnag"], $row2["indskor"], 
                     $row2["ostatok"], $row2["cena"], $row2["id"]);
    } else {
        print 'Нет в наличии';
    }
}

echo ('<br><br>');

?>
</body>
</html>