include("include/connection.php"); $searchQ = $_GET['lid']; $ctname = $_GET['ctname']; $rowperpage = 30; // counting total number of posts $allcount_query = "SELECT count(*) as allcount FROM sahitya_rachna_master where categoryid_reff='".$searchQ."'"; $allcount_result = mysqli_query($conn,$allcount_query); $allcount_fetch = mysqli_fetch_array($allcount_result); $allcount = $allcount_fetch['allcount']; $sqlsrch = "select * from sahitya_rachna_master where 1=1 "; if($searchQ!="") $sqlsrch .= " AND categoryid_reff='".$searchQ."' Order by rachna_id DESC limit 0,$rowperpage "; $ressearchQ=mysqli_query($conn,$sqlsrch); $numr=mysqli_num_rows($ressearchQ); $sqlcat="select category_name as catname from sahitya_category where catid='".$searchQ."'"; $rescat = mysqli_query($conn,$sqlcat); $rowcat=mysqli_fetch_assoc($rescat); ?>