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

How to Detect it is public_html or httpdocs?
How to check whether it is cPanel or Plesk?

If it found public_html perform <?php incl

UDP Multicast question
Hey,

Im not really in the know when it comes to network related programming and activitie

Working with Dates, help.
Sooo to make a long story short, here's what im trying to accomplish.

I need to create a drop

Error with Font and imagettfbbox
I keep getting an error that says "Warning: imagettfbbox() [function.imagettfbbox]: Could not f

Apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?

Php script to read msword file
hi,

I need to read a msword file and i want to print the contents in that word file.

i

PHP form help required
Hi all! Apologies in advance for having to message the forum for help. I know you must get a lot of

How to get variable value on next page
Hello friends
i am working on payentry page ..there i have this code.........

using a loop help
Hi guys , i need some help. I have this loop :
while ($row = mysql_fetch_assoc($Result)) { ?&

mail()
Hi all. I have a problem with emails. I am trying to set up a mail system where customers can subscr