if($_REQUEST['order'] == 'desc')
$order = "asc";
if($_REQUEST['order'] == 'asc')
$order = "desc";
if(!isset($_REQUEST['order']))
$order = "desc";
if (!isset($_REQUEST['field']))
$field = "ArtDate";
if($category != 'All' && $category != '')
$where = " AND ArtCategory LIKE '".$category."'";
$orderstmt = " ORDER BY ".$field." ".$order;
$sql = "SELECT * FROM TBL_Articles WHERE 1 ".$where.$orderstmt;
//echo $sql;
$res = @mysql_query($sql);// or die(mysql_error());
$total = @mysql_num_rows($res);
if($total){
?>
| Title |
Description |
Category |
Date |
}else echo '| No Articles exists.. |
';
if($total > $limit)
{
if($_REQUEST['page'])
$curpage = $_REQUEST['page'];
else
$curpage = 1;
$n = ceil($total/$limit);
$lowlimit = ($curpage-1)*$limit;
$psql = $sql." LIMIT ".$lowlimit.",".$limit;
//echo $psql;
$res = @mysql_query($psql);// or die(mysql_error());
}
$i = 0;
while($row = @mysql_fetch_array($res))
{
if($i%2 == 0)
$class = 'rowtext2';
else
$class = 'rowtext1';
?>
|
=stripslashes($row['ArtTitle'])?> |
=stripslashes($row['ArtDesc'])?> |
=stripslashes($row['ArtCategory'])?> |
=date('n/j/Y',strtotime($row['ArtDate']))?> |
$i++;}?>
if($total > $limit){?>
|
if($_REQUEST['page'] > 1){?>< Previous }?>
=$curpage?>
if($_REQUEST['page'] < $n){?>Next > }?>
|
}?>