|
 |
| |
|
|
Добавить скутер.
Страница:
$monthago";
$num = mysql_num_rows(mysql_query($query));
if ($num != 0){
$i_c = ceil($num/15);
for ($i=1;$i<($i_c+1);$i++){
if ($i != (@$page+1)){
echo "".$i." ";
}
else {
echo $i." ";
}
}
}
?>
| Модель (a/z) |
Год выпуска (a/z) |
Фото (a/z) |
Цвет (a/z) |
Состояние (a/z) |
Цена (a/z) |
$monthago ORDER BY `$sort` $how";
$query1 = "SELECT * FROM `scooter` WHERE (`status`='1' AND `sort`!='1' AND `sale` != 1) AND `date`>$monthago ORDER BY `$sort` $how";
}
else {
$query = "SELECT * FROM `scooter` WHERE (`status`='1' AND `sort`='1' AND `sale` != 1) AND `date`>$monthago ORDER BY `price` ASC";
$query1 = "SELECT * FROM `scooter` WHERE (`status`='1' AND `sort`!='1' AND `sale` != 1) AND `date`>$monthago ORDER BY `price` ASC";
}
$result = mysql_query($query);
$style = 1;
while (@$row = mysql_fetch_array($result,MYSQL_BOTH)){
echo "| $row[firma] $row[model] | ";
echo "$row[god] | ";
echo "$row[photo_status] | ";
echo "$row[color] | ";
echo "".@$sost_array[$row[sost]]." | ";
echo "$row[price] USD | ";
echo " ";
if ($style == 1){
$style = 2;
}
else {
$style = 1;
}
}
$num_rows = @mysql_num_rows($result);
if (isset($page)){
$page1 = $page*(15-$num_rows);
}
else {
$page1 = 0;
}
$query1 .= " LIMIT $page1, ".(15-$num_rows);
$result = mysql_query($query1);
while (@$row = mysql_fetch_array($result,MYSQL_BOTH)){
echo "| $row[firma] $row[model] | ";
echo "$row[god] | ";
echo "$row[photo_status] | ";
echo "$row[color] | ";
echo "".@$sost_array[$row[sost]]." | ";
echo "$row[price] USD | ";
echo " ";
if ($style == 1){
$style = 2;
}
else {
$style = 1;
}
}
if (@mysql_num_rows($result) == 0){
echo "| База данных пуста";
}
?>
|
Страница:
$monthago";
$num = mysql_num_rows(mysql_query($query));
if ($num != 0){
$i_c = ceil($num/15);
for ($i=1;$i<($i_c+1);$i++){
if ($i != (@$page+1)){
echo "".$i." ";
}
else {
echo $i." ";
}
}
}
?>
Добавить скутер.
Внимание! Скутеры и мопеды представлены частными лицами
| |
|
