Re: putting db results in a 5 x 1 table

• From: Schraalhans Keukenmeester <nomail@xxxxxxxxxx>
• Date: Tue, 27 Sep 2005 04:28:59 +0200

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

I think you are after the LIMIT clause.
Select * from db where blabla LIMIT 5
See MySQL manual for complete coverage of LIMIT usage.

SH
.

• References:
  • putting db results in a 5 x 1 table
    • From: Eddie Biscomb

• Prev by Date: php: number_format()
• Next by Date: Coding style: PHP with Complex MySQL statements
• Previous by thread: putting db results in a 5 x 1 table
• Next by thread: php: number_format()
• Index(es):
  • Date
  • Thread

• Security
• UNIX
• Linux
• Coding
• Usenet

• Archive
• About
• Privacy
• Search
• Imprint