limit display to 3 results

[sallystudent]

Hi,

I am querying my database and the returned results can be greater than 3 and I want to display 3 results and if there is more have a NEXT button that can be pressed and display the next 3 etc

Anyone have any ideas???

Thanks

[synergypoint]

try using the limit feature in your SQL statement.

[sallystudent]

Hi,

Yes - I have used that, and it LIMITs the results to 3. BUT I want it to show 3 results a page and the rest be shown on the following pages, with a NEXT/Prev button

[synergypoint]

Then pass values for the stating record in your limit

Select .... from ... where ... limit $startVal, $numRecs

$numRecs=3 or you could make that a user selectable value.

The first page view $startVal=0

The second page view $startVal=3

The third page view $startVal=6

and on and on and on and on...

[sallystudent]

Hiya,

how wud write this?? Here is my current code:

$query = "SELECT * FROM customer_table WHERE ".$searchtype." like '%".$searchterm."%'LIMIT 12 ";

$result = mysql_query($query)or die(mysql_error());

$num_results = mysql_num_rows($result);

echo '<P><strong>Number of items found: '.$num_results.'</strong></p>';

for ($i=0; $i <$num_results; $i++)

{
$row = mysql_fetch_array($result);
echo '<p><strong>'.($i+1).'.Customer Number: ';
echo htmlspecialchars(stripslashes($row['Cust_Id']));
echo '</strong><br />First Name: ';
echo stripslashes($row['First_Name']);
echo '<strong><br />Surname: ';
echo stripslashes($row['Surname']);

echo '<img src="'.$row['Image'].'" />';

}