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 didnt code this but I need help with it
I'm sorry. i'm not a coder. I have this script for forcing download and previewing mp3. The guy that

PHP page loading in Firefox but not in IE
hello,

i am currently doing a project in PHP and i have a problem. If I view the project in M

error help - Dynamic Image
I've been working on making my site less cluttered in the directories and more secure lately. In an

Basic Forum Tutorial
Hi, I'm new to PHP. I want to build a basic forum for my site using PHP and MySQL. I've searched t

post to self
Trying to get my form to submit to itself. However I am also trying to use an image for my submit bu

Function
How can I make this function that once you click the link in the code it takes you to a new page wit

Save username into DB
OkaY so I got my blog to actually save the posts and whatever, all I need now is for it to keep the

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

Class not found error
I am getting Class 'index' not found in Eval function:

//write config

$pat

Help uploading .JPG
I have a problem with upload images when the ending is .JPG capitalized.. I really don't know what c