//echo "halo1 " . $category;
if(($_POST['category'] == 'ALL') || ($_POST['category'] == '') || ($category == 'ALL'))
//if(($category == 'ALL') || ($category == ''))
{ //echo "cat_ques1 " . $cat_ques . " and postcategory " . $_POST['category'] ;
if(($_POST['category'] == 'ALL') || ($category == 'ALL'))
{
$category = 'ALL';
$sql="select * from tb_question";
$result1=mysql_db_query($dbname,$sql);
$total=mysql_num_rows($result1);
$totalpages=ceil($total/$each);
$goto = ($page-1)*$each;
$sql="select * from tb_question order by id_ques desc limit $goto,$each";
$result=mysql_db_query($dbname,$sql);
}
else{// calculate number of topic
$cat_ques = $category;
//echo "cat_ques2 " . $cat_ques . " and postcategory" . $_POST['category'] . " and cat " . $cat;
$sql="select * from tb_question where cat_ques = '$cat_ques'";
$result1=mysql_db_query($dbname,$sql);
$total=mysql_num_rows($result1);
$totalpages=ceil($total/$each);
$goto = ($page-1)*$each;
//echo "total " . $total . " totalpages " . $totalpages;
$sql="select * from tb_question where cat_ques = '$cat_ques' order by id_ques desc limit $goto,$each";
$result=mysql_db_query($dbname,$sql);
}
}
else{ // calculate number of topic
//if($cat == '')
// {
// $sql="select * from tb_question";
// $result1=mysql_db_query($dbname,$sql);
// $total=mysql_num_rows($result1);
// $totalpages=ceil($total/$each);
// $goto = ($page-1)*$each;
// $sql="select * from tb_question order by id_ques desc limit $goto,$each";
// $result=mysql_db_query($dbname,$sql);
// }
//else{
$cat_ques = $_POST['category'];
//$category = $_POST['category'];
//echo "cat_ques3 " . $cat_ques . " and category" . $_POST['category'] . " and cat " .$cat;
$sql="select * from tb_question where cat_ques = '$cat_ques'";
//echo $sql;
$result1=mysql_db_query($dbname,$sql);
$total=mysql_num_rows($result1);
$totalpages=ceil($total/$each);
$goto = ($page-1)*$each;
$sql="select * from tb_question where cat_ques = '$cat_ques' order by id_ques desc limit $goto,$each";
$result=mysql_db_query($dbname,$sql);
// }
}
?>
|
|
| |