Could someone possibly point me in the right direction as to why this query isnt showing the results that I want when adding a category but, it allows me to pull the full contents of the database and display them when no WHERE or RLIKE is present?
Quote:
<?php
include('db.php');
if (isset($_GET['page_no']) && $_GET['page_no']!="") {
$page_no = $_GET['page_no'];
} else {
$page_no = 1;
}
$total_records_per_page = 10;
$offset = ($page_no-1) * $total_records_per_page;
$previous_page = $page_no - 1;
$next_page = $page_no + 1;
$adjacents = "2";
$result_count = mysqli_query($con,"SELECT COUNT(*) As total_records FROM `Directory`");
$total_records = mysqli_fetch_array($result_count);
$total_records = $total_records['total_records'];
$total_no_of_pages = ceil($total_records / $total_records_per_page);
$second_last = $total_no_of_pages - 1; // total page minus 1
$result = mysqli_query($con,"SELECT * FROM Directory LIMIT $offset, $total_records_per_page");
while($row = mysqli_fetch_array($result)){
echo "<p align=\"left\" class=\"style2\"><strong><a href=". $link .">". $row['Name'] ."</a></strong>";
echo "<p align=\"left\" class=\"style2\">". $row['Description'] ."</a>";
echo "<br />";
}
mysqli_close($con);
?>
|
I've tried adding the following to the query itself with no luck:
Quote:
|
$result = mysqli_query($con,"SELECT * FROM Directory WHERE Category RLIKE catfood LIMIT $offset, $total_records_per_page");
|
The amount of pages in the pagination changes, it just wont show the data when I add the WHERE Catergory RLIKE catfood part :/
What am I missing please?
