putting database results in a 5x1 table

I have a db of tens of thousands of entries. It's not too hard to pull all the entries and build a table that displays them one at a time, but in my case, that will be a huge waste of space. What I want to do is put one record in each of the columns. I thinks it's possible to do because I have seen very elaborate thumbnail gallery scripts to do this. I just want to be able to put two or three strings of text from each record into each row, and a checkbox. Here's sample of what I mean:

<table width="76%"  border="1" cellspacing="1" cellpadding="1">
  <tr>
    <td>$record1Line1<br>$record1$Line2<br>
<input type="checkbox" name="$record1checkbox" value="checkbox"></td>
    <td>$record2Line1<br>$record2$Line2<br>
<input type="checkbox" name="$record2checkbox" value="checkbox"></td>
    <td>$record3Line1<br>$record3$Line2<br>
<input type="checkbox" name="$record3checkbox" value="checkbox"></td>
    <td>$record4Line1<br>$record4$Line2<br>
<input type="checkbox" name="$record3checkbox" value="checkbox"></td>
    <td>$record5Line1<br>$record5$Line2<br>
<input type="checkbox" name="$record5checkbox" value="checkbox"></td>
  </tr>
</table>

I want to pull about 200 records at a time from the db and display as described above. How can I tell php to take five records from my result set and display above, then loop through the result set until I'm done?

Thanks much for any guidance you can offer.

Ed
.

Relevant Pages

  • Re: need help with images
    ... >this will pull out all the entries of the current month and year that we are ... >how will the tblPics table pull out all the particular images for the blog ... I assume you loop through the blog entries. ... Start loop to display results ...
    (alt.php)
  • RE: Referrencing to a diff cell
    ... just a possibility of 2 entries, or can there be more on out to the ... ALLthe lists that when i update the indivial pages, ... data validation for the first column. ... I can get it to pull down and use absolute column, but when pull sideways, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Access Table Sorting/Query Last Function
    ... I've put in a number of test entries to ensure it works, ... of the Lastin your totals query. ... I've been designing a database that basically works off two tables. ... I've done this so that I can pull the last entered ...
    (microsoft.public.access.tablesdbdesign)
  • Re: putting database results in a 5x1 table
    ... Eddie Biscomb wrote: ... > I have a db of tens of thousands of entries. ... It's not too hard to pull ... > set and display above, then loop through the result set until I'm done? ...
    (comp.lang.php)
  • RE: How to print select months from worksheet
    ... Use a helper column to achieve this. ... only those entries will print out. ... I need to know if there is a way to pull and print only the most ... recent 3 months worth of data from this sheet. ...
    (microsoft.public.excel.misc)