- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
if ($var==0 && $var3==0 && $var4==0) {
$qr_result = mysql_query("SELECT type_id, image_plan, section_type, house_number, section_number_real, rooms, prod FROM `psp_gen_plan_type` WHERE prod=0 ORDER BY `house_number` ASC" . $db_table_to_show)
or die(mysql_error()); }
elseif ($var!=0 && $var3!=0 && $var4!=0){
$qr_result = mysql_query("SELECT type_id, image_plan, section_type, house_number, section_number_real, rooms, prod FROM `psp_gen_plan_type` WHERE house_number='$var' AND prod=0 AND section_type='$var3' AND rooms='$var4'" . $db_table_to_show)
or die(mysql_error()); }
elseif ($var!=0 && $var3==0 && $var4==0){
$qr_result = mysql_query("SELECT type_id, image_plan, section_type, house_number, section_number_real, rooms, prod FROM `psp_gen_plan_type` WHERE house_number='$var' AND prod=0 ORDER BY `section_number_real` ASC" . $db_table_to_show)
or die(mysql_error()); }
elseif ($var==0 && $var3!=0 && $var4==0){
$qr_result = mysql_query("SELECT type_id, image_plan, section_type, house_number, section_number_real, rooms, prod FROM `psp_gen_plan_type` WHERE section_type='$var3' AND prod=0 ORDER BY `house_number` ASC" . $db_table_to_show)
or die(mysql_error()); }
elseif ($var==0 && $var3==0 && $var4!=0){
$qr_result = mysql_query("SELECT type_id, image_plan, section_type, house_number, section_number_real, rooms, prod FROM `psp_gen_plan_type` where rooms='$var4' AND prod=0 ORDER BY `house_number` ASC" . $db_table_to_show)
or die(mysql_error()); }
elseif ($var!=0 && $var3==0 && $var4!=0){
$qr_result = mysql_query("SELECT type_id, image_plan, section_type, house_number, section_number_real, rooms, prod FROM `psp_gen_plan_type` where house_number='$var' AND prod=0 AND rooms='$var4' ORDER BY `house_number` ASC" . $db_table_to_show)
or die(mysql_error()); }
elseif ($var!=0 && $var3!=0 && $var4==0){
$qr_result = mysql_query("SELECT type_id, image_plan, section_type, house_number, section_number_real, rooms, prod FROM `psp_gen_plan_type` where house_number='$var' AND prod=0 AND section_type='$var3' ORDER BY `section_number_real` ASC " . $db_table_to_show)
or die(mysql_error()); }
elseif ($var==0 && $var3!=0 && $var4!=0){
$qr_result = mysql_query("SELECT type_id, image_plan, section_type, house_number, section_number_real, rooms, prod FROM `psp_gen_plan_type` where rooms='$var4' AND prod=0 AND section_type='$var3' ORDER BY `house_number` ASC " . $db_table_to_show)
or die(mysql_error()); }
Кинули сайт на доработку. Вот с таким вот фильтром.
> Кинули сайт на доработку.