Расширенный поиск НАСОСОВ


(812)
 г
 

  = $podfrom "; else $tmp1 = ""; if(!empty($podto)) $tmp2 = " and pod <= $podto "; else $tmp2 = ""; // Если посетитель ввёл цифру "От" if(!empty($napfrom)) $tmp3 = " and nap >= $napfrom "; else $tmp3 = ""; // Если посетитель ввёл цифру "До" if(!empty($napto)) $tmp4 = " and nap <= $napto "; else $tmp4 = ""; if(!empty($wattfrom)) $tmp5 = " and watt <= $wattfrom "; else $tmp5 = ""; if(!empty($wattto)) $tmp6 = " and watt <= $wattto "; else $tmp6 = ""; /* Выполняем SQL-запрос */ $query = "SELECT Type, pod, rpm, nap, watt, link FROM nasos_01 WHERE (id_nasos = 1) or 1 = 1 ".$tmp1.$tmp2.$tmp3.$tmp4.$tmp5.$tmp6; $result = mysql_query($query) or die("Query failed : " . mysql_error()); /* Выводим результаты в html */ // print " ?>

\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { print "\t\n"; foreach ($line as $col_value) { print "\t\t\n"; } print "\t\n"; } print "
$col_value
\n"; include "end.php"; ?>