| Pages :
switch($action){
case 'title':
if($url_min =='' && $url_max =='')
$query ="Select s4s.id, title, url, price,
traffic,
DATE_FORMAT(date_started, '%d.%m.%y') as date_started , income from s4s where
and
stat = 1 order by price Limit 0 ,10";
else
$query ="Select s4s.id, title, url, price,
traffic,
DATE_FORMAT(date_started, '%d.%m.%y') as date_started , income from s4s where
stat = 1 order by title Limit $url_min ,10";
echo page_numbering('title');
break;
case 'price':
if($url_min =='' && $url_max =='')
$query ="Select s4s.id, title, url, price,
traffic,
DATE_FORMAT(date_started, '%d.%m.%y') as date_started , income from s4s where
stat = 1 order by price Limit 0 ,10";
else
$query ="Select s4s.id, title, url, price,
traffic,
DATE_FORMAT(date_started, '%d.%m.%y') as date_started , income from s4s where
stat = 1 order by price Limit $url_min ,10";
echo page_numbering('price');
break;
case 'income':
if($url_min =='' && $url_max =='')
$query ="Select s4s.id, title, url, price,
traffic,
DATE_FORMAT(date_started, '%d.%m.%y') as date_started , income from s4s where
stat = 1 order by income Limit 0 ,10";
else
$query ="Select s4s.id, title, url, price,
traffic,
DATE_FORMAT(date_started, '%d.%m.%y') as date_started , income from s4s where
stat = 1 order by income Limit $url_min ,10";
echo page_numbering('income');
break;
case 'date':
if($url_min =='' && $url_max =='')
$query ="Select s4s.id, title, url, price,
traffic,
DATE_FORMAT(date_started, '%d.%m.%y') as date_started , income from s4s where
stat = 1 order by date DESC Limit 0 ,10";
else
$query ="Select s4s.id, title, url, price,
traffic,
DATE_FORMAT(date_started, '%d.%m.%y') as date_started , income,date from s4s
where
stat = 1 order by date DESC Limit $url_min ,10";
echo page_numbering('date');
break;
default:
$query = "Select id, title, url,
price, traffic,
DATE_FORMAT(date_started, '%d.%m.%y') as date_started, income from s4s where
stat = 1 order by date Desc Limit 0 ,10";
echo page_numbering('date');
}
?>
|