Hi.
Part of a website i am working on has a lot of articles. These pages are all in plain html. I wanted to design a mysql database for these articles. I was thinking of something like this.....
Database articles
col_id--article id
col_intro--what the article is about
col_title--title of article
col_article--the complete article
My problem is that some articles are so big they will need more then one page. If i copy and paste everything into col_article and then print that, it will just be in one very long page. I want it to display one page at a time and then have a "next page" link at the bottom.
So i have some articles that will fit in one page and others that are too long to put in one page.
If i store the first page in col_article where do i store the rest of the pages?
If i store the whole article in col_article is there any way to separate that into pages?
What would you do?
All help is appreciated.
thanks.
Part of a website i am working on has a lot of articles. These pages are all in plain html. I wanted to design a mysql database for these articles. I was thinking of something like this.....
Database articles
col_id--article id
col_intro--what the article is about
col_title--title of article
col_article--the complete article
My problem is that some articles are so big they will need more then one page. If i copy and paste everything into col_article and then print that, it will just be in one very long page. I want it to display one page at a time and then have a "next page" link at the bottom.
So i have some articles that will fit in one page and others that are too long to put in one page.
If i store the first page in col_article where do i store the rest of the pages?
If i store the whole article in col_article is there any way to separate that into pages?
What would you do?
All help is appreciated.
thanks.