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

IF STATEMENT HELP
Hi
i have created a calendar from a table:

Code: Calendar: October 2009
<table w

Wierd echo error?
Hi, i got the most wierd php error ever and i don't know why..
Code: echo "<t

Progress bar tracking file downloads
Hey guys, was wondering if there was a way to track how far a file has been downloaded. I know there

php libs/ browsercap.in
ok i have a host that refuses to stay current. they control my php settings and libs. is there a way

Links not updating
I'm trying to fuel a simple navigation system for a news section. It works fine when it comes to ret

Line break?
Hi, I'm new to the forum and new to php. I'm not sure if I'm using the correct terminology so here i

utl_file open error
i have file in the unix path

Path /popdev01/pop/popdevb/tfi/

File name

include
Hi I have this way of licensing my PHP application, and I want to know if you guys can answer some q

php problem?
I don't think I'm stupid, but maybe I am.

I am working on a sit for a friend I am try to put

Need help to modify php ELSE code
I'm trying to find a way to have the php code display a message if there is no inventory listed in t