Hi there,

I am using the following code to display results drawn from MYSQL databse on my webpage:


<?php
include("....");

$connection = mysql_connect($host,$user,$password)
or die ("couldn't connect to server");
$db = mysql_select_db($database,$connection)
or die ("Couldn't find databse");

/* Select pets of the given type */
$query = "SELECT * FROM Blah Blah";
$result = mysql_query($query)
or die ("Couldn't execute query.");
echo "<tr><td class='header' colspan='7'>Under Fiver</td></tr>\n";
echo "<tr class='film_box' colspan='7'>\n";
echo "<td width='5'></td>";
while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{




/*display row for each pet */

if ($row['TitleID'] > 100000)
{
echo "<td height='60' width ='100' align='center'> <img src='../images/images/V0{$row['TitleID']}.JPG' border='0' width='60' height='85' alt='{$row['Title']}'>
<br>
{$row['Title']}
<br>
}
else {
echo "<td height='60' width ='100' align='center'> <img src='../images/images/V0{$row['TitleID']}.JPG' border='0' width='60' height='85' alt='{$row['Title']}'>
<br>
{$row['Title']}
<br>
}
echo "<td width='5'></td>";

}echo "</tr>";
?>


The command works fine, but it displays every result in the same line and i wish to limit the amount of results displayed per row to 7.

How do i do this? If you need me to explain with more clarity then let me know and i'll do my best!

Thanks in advance for any help.

add a for(),
for ($i = 0; $i < 7 ; $i++) {
[[[[[[do the echoing here]]]]
}

would that help?

would i put that in before the "where" statement?

what does if do and what does else? (in "display row for each pet")

i am too tired to try and follow the code right now.

these can be ignored - they are specific to the IDs given to each pet

no no no!! There is no need to use PHP for this, mySQL can do this for you (it'll be faster too). mySQL has a handy little parameter for such functions as SELECT, called LIMIT.

Basically, this parameter tell mySQL to limit the result set to a certain record range. So for you're example you want 7 results per page, so we add this to the end of the SQL statement

PHP Code:

LIMIT 0 , 7 


This will give us the first 7 results (the second argument in the parameter) starting from the first record (which will always be 0).

But what if you want to show the next page?? Well that's pretty simple, all we have to do is supply an "offset" variable in the query string, so we've gone through the first 7 records right? We need the next 7, so our offset is going to be 8 (because the first record was 0, think bout it ). Thus our statement will be

PHP Code:

LIMIT 8 , 7 


This will give us 7 results, starting (and including) from the 8th record.

excellent - this is what i was looking for.

however i want to have more than one row on each page. so i appreciate that i just have to use LIMIT 8 , 7 and LIMIT 15,7 etc. But what if there are 1000's of results returned, i obviously don't want to have to do this a 1000 times!

any ideas?

i think this would be a good while () .... but now i'm not sure i'm looking at the easiest solution again

use a variable for the count and multiply it by 7 on every step.

I'm not sure im understanding you clearly? The SQL statement won't return one row, it will return 7 into the mysql_fetch_array(), so the while that you have there (while ($row = mysql_fetch_array($result,MYSQL_ASSOC))) does that anyway.

That's what the loop is for, so you don't write out seperate code for every result row.

To find out how many pages you're going to need per search, all you do is divide the total result set for the search (so you'll have to do a seperate SQL SELECT before any code) and divide it by 7 (or however many results per page) and then get PHP to round to the nearest, highest number.