paginate search result

Posted on 16th Feb 2014 07:03 pm by admin

Hi, I have a paginations script to display data from my database but i would like to paginate someones search results. I have this script but get an error that says "syntax error, unexpected '=', expecting '}'" for this if(!$start){$start = 0;}

Code: <?php
include ("connect.php");
$per_page = 20;
$start = $_GET ['start'];
$record_count = mysql_num_rows (mysql_query("SELECT * FROM flats WHERE `location` LIKE '%$keyword%' OR
`location` LIKE '%$keyword%'));
$max_pages = $record_count / $per_page; // may come out as a decimal
if(!$start){$start = 0;}
$get = mysql_query("SELECT * FROM flats WHERE `location` LIKE '%$keyword%' OR
`location` LIKE '%$keyword%' ORDER BY date_posted DESC LIMIT $start, $per_page");
?>

Your Answer:

Login to answer

Other forums

preg_replace question
Hello!!

I hope someone can help me with preg_replace.

I load two tables from an extern

empty() error
Why does

Code: empty($USER_ID = $_SESSION["USER_ID"])
create this error...

Hashing?
Hi, I was hoping to take a string value then convert it - consistently - across each of our pages in

Strip Slashes Help
I've got a script that i've downloaded of the net to edit multiple fields from my sql database, and

EU VAT Package 2010
Does any one know whether SAP will be developing new reporting functionality due the new VAT rules t

WHYISNT THIS MYSQL STATEMNT NOT WORKING? (php)
caps because its absolutely rediculous.
i dontunderstand why its not working. there is a column c

SESSION CHECK WORKS "MOST" of the time... whats going on?
i have a sign in check thats included in every page that is a members only page which is basically a

scandir clients directory
hi,
how can i scandir the clients directory? i need a script that when i click a button it will u

Any meaningful project for a new C++ programmer?
I want to do some meaningful program, so I can help myself to learn

Assume I know the fol

Sessions Value Not Saved
Hi,

Im making a login form and im using this code:
Code: if($login=="true"){