4) {$sort = 1;} /* Запрос на получение строк из таблици товаров $tovar = номер категории товара Сортировка по цене $sql_query_sort_lots = "SELECT * FROM ".$tablename_id_tovar." ORDER BY price+0 ASC"; */ if ($sort == 1) { $sql_query_sort_lots = "SELECT * FROM ".$tablename_lot." WHERE lot_view=1 ORDER BY ASCII(UPPER(lot_name))"; } if ($sort == 2) { $sql_query_sort_lots = "SELECT * FROM ".$tablename_lot." WHERE lot_view=1 ORDER BY ASCII(UPPER(lot_name)) DESC"; } if ($sort == 3) { $sql_query_sort_lots = "SELECT * FROM ".$tablename_lot." WHERE lot_view=1 ORDER BY lot_price+0 ASC"; } if ($sort == 4) { $sql_query_sort_lots = "SELECT * FROM ".$tablename_lot." WHERE lot_view=1 ORDER BY lot_price+0 DESC"; } $result_query_sort_lots = mysql_query($sql_query_sort_lots) or die ("$h_error".mysql_error()."$f_error"); if ($result_query_sort_lots) { while($row = mysql_fetch_array($result_query_sort_lots)) { $lot_id[] = cutty_html($row['lot_id']); $lot_name[] = cutty_html($row['lot_name']); $lot_price[] = cutty_html($row['lot_price']); $lot_novelty[] = cutty_html($row['lot_novelty']); $lot_link[] = cutty_html($row['lot_link']); } } ?>

СПИСОК ТОВАРОВ НА GPS.KZ "); } ?> Список товаров Сортировка по названию товара: "; ?> "; ?> | Сортировка по цене товара "; ?> "; ?> Название товара Цена ".$lot_name[$i]." "); if($lot_price[$i]<>"0") {echo number_format($lot_price[$i], 0, '', ' '); } else { echo $lot_link[$i]; } echo ("