Diplaying table data

[Okami]

I have a database table that contains 50 items. I can display them all, but would like to know how to display 4 or 5 items at a time.

I would like to display the first 4 items in one table, another 4 items in another table.

[BeastRider]

You use a SELECT statement with conditions.

Example: without looking at the contents of the records at all:

SELECT * from $table
LIMIT 5,5

This skips 5 records, then retrieves the next five.

Or, you get rows based upon expressions used to compare fields in the table against desired values. For example:

SELECT * from $table
WHERE firstname = "fred" and age = 23

[Okami]

Once I have put all the items from my table into an array, can I display just 1 or 2 items.

I am using a foreach loop to display the items, what other options do I have.