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

I need help with formatting date from mysql! with php!
Hello guys

*Note: this is a php question not MySQL question, please do not move it to mysql s

add 20 000 to the rowcnt
Hi ...
I need to add 20 000 to the row count but just cant find a way to do this i am new to php

with clause
hi all, i have a big query that usually access the same table more than once. for example, i have s

help with Get_
ok some how this is not working i am not sure what i am doing wrong here but what this does is when

Calander layout
Hi i know this sounds like a simple question but i cant find the answer to it anywhere i have added

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

Help with echo()
I'm having some problems with this code:

Code: echo '
<A HREF="jav

header redirect problems? please help
Ok i am making a site that generates youtube thumbnails and i am generating an image that displays 1

Include ("Absolute Path") of a file?
I'm not sure what I'm doing wrong. I am writing my php code in the same directory of the file that

listing help
Hi,

at first, great new design!!! I like it,

i got a problem,

I want to list so