if i have a table which has field like "primary key, name, colour" and i want to select all the lines which have the same key, but one by one sequentially (i want them all to appear on separate pages of a website, with a "next one" button), what do i do?

Hi,

what program language do you use to generate your sites?

I assume, that the "primary key" you mentioned is not the primary key used in the table you query, but any other table. If not, I don't think that your layout would work since all primary keys of any table must be unique... I call the primary key of the table queried "real primary key".

What I would do is
1)
fetching all real primary keys of the lines I am interested in and store it in any session variable. This way, I know how many sites to generate etc. I can show a "this is page 3 of 343", e.g.
2)
query the database on each site request using the primary key stored in the session variable. ("select * fro mytable where id=$currentid")

Or:
1) fetching all queries within one large query and use it as session variable over all site requests.
No not really. I would do what written above...

Greet-o-mente

sorry what's all this about session variables? i think i'll be using perl.
(yes, its the primary key of another table, sorry )

sorry what's all this about session variables? i think i'll be using perl.
(yes, its the primary key of another table, sorry )