php/mysql- grabbing id from previous page

sleepyescapade

I have a page which displays the ranges in a particular category. The categories are in a table of their own on my database. Lets say for example the id for the category Music is 1. I'd have 'category.html?id=1'.
On the category page there is then a seletion of the different ranges. The ranges also have a table of their own in the database and each indivudual range would use its individual id, example 'range.html?id=1&catid=1'

On the range.html page it displays all the products in that range within the previous category. These can then be viewed individually in a 'product.html' page. Products have their own table in database. I want the link to be something like 'product.html?rangeid=1&prodid=27'.

I hope what I'm trying to explain makes sense. My main issue is carrying all the id's from the previous page to the range.html or product.html pages

Adam

So it's the links themselves you're having trouble with?

sleepyescapade

No i can do those fine, my problem is displaying the correct ranges and products that are linked to the category/range/product ids in the links (i.e range.html?range=1&prodid=3).

Winters

Are you looking for help with some sort of php/mysql pagination script?

To list X amount of items per page, from a certain category and browse through them?

forbairt

megcork wrote: »

No i can do those fine, my problem is displaying the correct ranges and products that are linked to the category/range/product ids in the links (i.e range.html?range=1&prodid=3).

I assume you've got a table linking the category and the range together ?
categoryID,rangeID
or something like that to link the two ?

so if you know the range select the category of that range ?

sleepyescapade

Thanks guys for your help, apologies I didn't have time to post back but got this sorted in the end