Displaying X number of Results

Anon

Hello.

I'm pulling information from a database and inserting it into a table row. I
want to be able to control the number of results displayed before a new row
is formed. In another words, I want three results displayed before a new
table row is created. I'll post my code, if it helps:

while($myRow = mysql_fetch_array($result))
{
$book_img = $myRow["book_img"];
$book_id = $myRow["book_id"];
$book_title = $myRow["book_title"];
$book_author = $myRow["book_author"];
$book_price = $myRow["book_price"];
$book_desc = $myRow["book_desc"];

//right now, it simply adds a column to the table. I want 3 columns per row
before a new row is started...
echo ("<td> ");
echo ("$book_img ");
echo (" $book_title ");
echo (" $book_author " . "  
$book_price ");
echo (" $book_desc ");
echo ("</td>\n\n");

}

Anon

Try
//set cols to be the numbe rof columns you want:
$cols = 3;
$i = 1;
print '<tr>';
while ($row = mysql_fetch_array($result)) {
if (is_int($cols / $i)) {
printf('<td> %s %s %s %s %s</td></tr><tr>', $book_img, $book_title, $book_author, $book_price, $book_desc);
}
else {
printf('<td> %s %s %s %s %s</td>', $book_img, $book_title, $book_author, $book_price, $book_desc);
}
}
print '</tr>';

Anon

Try using this in your select statment:
$limit = 10;
SELECT * FROM somewhere LIMIT $limit
That will pull records 0-9

If you want to pull the next 10 records try this:
SELECT * FROM somewhere LIMIT $limit, 10;
That will pull records 10-19

The first number is how many records to pull. The second number is where to start from.
Hope that helps.

Anon

I think what he was after was displaying three html columns per row, not three db rows per page.

Anon

That is correct. Thanks again for all the helpful responses.