Tree display of Categories/Items

[Ragnar_7]

Hi everyone,

I have a question which has been puzzling me for quite some time now, and
my SQL skills are not good enough to come up with a proper solution.

I have a product catalogue which should be able to display anything with a certain letter (A,B,C)
in it on a page. So it should display Categories and their products on that one page like so:

(All starting with say the letter 'C')

Category 1
- Product 1
- Product 2

Category 2
- Product 3
- Product 4

Now the problem with that is that the page it should display this information on will also need
to have pagination (ie. back, [1][2][3], next). How on earth can I get 1 recordset that would contain that information so it can be paginated properly ?

I'm using PHP and MySQL 3.23.x (upgrading not possible at the moment).

If the above is not possible I might be able to settle for the option below.

(All starting with say the letter 'C')

Category 1
Category 2
- Product 1
- Product 2
- Product 3
- Product 4


I'd really appreciate ANY suggestions, as I have reached my limits with this it seems.