limit results on one page

[karmakiller]

Hi,

I am very new to php (three weeks) and i am trying to do a search database etc...

im doing ok ( i think...lol)

I am getting my results to show in the order i want now, but i want my results to show a max of 10 on each page... the problem is I dont know how to only show 10 results on one page and to have a next button that will show the next 10 and so on and so on.

please please could someone help as it is doig my head in!!

here is my code so far

<?php
  mysql_connect (localhost, root, louvain);
  mysql_select_db (directory);

  if (empty($townorcounty))
  {
    $townorcounty = '%';
  }

  if (empty($county))
  {
    $county = '%';
  }

  $result = mysql_query ("SELECT * FROM `company` WHERE  (`town` LIKE '$townorcounty%' OR `county` LIKE '$townorcounty%') ORDER BY package"); 

  if (!mysql_num_rows($result))
  {
    print ('No search results');
  }
  else
  {




print ('<table width="472" border="0" cellpadding="0" cellspacing="5" class="table">');
$ID = 0;
while ($row = mysql_fetch_array($result))
{
  # Create the HTML image code.
  //<a href="mailto:">email</a>
  //<a href="http://www.">www.spacekitchens.co.uk</a>

$emailcode = '<a href="mailto:'.$row['emailaddress'].'"><img src="' . $row['email'] . '" alt="Click Here To Email" border="0" />';
$imgcode = '<a href="'.$row['website'].'"><img src="' . $row['photo'] . '" alt="Company Logo" border="0" />'; 
$webcode = '<a href="'.$row['website'].'"><img src="' . $row['websiteimg'] . '" alt="go to website" border="0" />';
$linecode = '<img src="' . $row['space'] . '" alt="go to website" border="0" />'; 
$today = date("d/m/Y - ");

//$variable1=$row["Company"]; 
//$variable2=$row["title"]; 
//$variable3=$row["county"]; 
//print ('<tr>');
//print ('<td><strong>');
//print ("$variable1");
//print ("$variable2");
//print ("$variable3");

print ('<td><strong>');
//print $today;
print $row['Company'];
print ('</strong>');
print $row['title'];
print('</td>');
print('</tr>');

print ('<tr>');
print ('<td>');
print $row['address'];
print $row['town'];
print $row['county'];
print $row['postcode'];
print('</td>');
print('</tr>');

print ('<tr>');
print ('<td>');
print $imgcode;
print('</td>');
print('</tr>');

print ('<tr>');
print ('<td>');
print $row['desc'];
print('</td>');
print('</tr>');

print ('<tr>');
print ('<td>');
print $emailcode;
print $webcode;
print('</td>');
print('</tr>');

print ('<tr>');
print ('<td>');
print $linecode;
print('</td>');
print('</tr>');

++$ID;
}
print ('</table>');

  }
?>

[MrQcue]

You have to use the LIMIT function in your mysql-query. The reference for this -> http://dev.mysql.com/doc/refman/4.1/en/select.html and search for 'Limit' on that page.

You can select the start/end row of your query. So if you want to show 5 rows starting at row 11 of your query, it will look like this:

SELECT col1, col2, col3 FROM table_name WHERE col1 = 'John Doe' LIMIT 10, 5

But first of all you need to know how many result pages you have to calculate the total of pages you have print on the bottom of the page. To do that you first have to calculate the total of results of that query without the 'Limit' thing.

[karmakiller]

right i get the LIMIT thing, and i have just tested it.... but im confused how to create the amount of pages i need?????

i want all the results, just on seperate pages.... ie p1,p2,p3

[Roger_Ramjet]

This is called pagination and there are untold threads that deal with every aspect of it - so please do a search.

[karmakiller]

thanks for that.... ill take a look, now that i know the exact search phrase..

[Roger_Ramjet]

Start with Raul's answer in this thread , it's about 2 threads down form yours in theis forum.

[ionescu_raul]

Roger Ramjet wrote:

Start with Raul's answer in this thread , it's about 2 threads down form yours in theis forum.

Thanks Roger Ramjet! U are too kind to recommend my project! 🙂