Tilted Forum Project Discussion Community - View Single Post

thecow · 06-03-2003, 08:12 PM

You will want a php page(end the page with .php). The code will need to go to the articles table in MySQL and sort them by date. Then grab and print the first 8-10(however many you want). Then you can do the same thing for an archives page - only skip the first 8-10 and then print the rest.

Also, I believe it is better to setup your MySQL with 2 tables for articles - one with everything but the main text, and one with just the text and some ref to the other info in the first table. I believe it speeds up processing when searching etc.

Not sure about the CMS stuff, just know I didn't use it for my personal page.

06-03-2003, 08:12 PM	#7 (permalink)
thecow Crazy Location: Fayetteville, AR	You will want a php page(end the page with .php). The code will need to go to the articles table in MySQL and sort them by date. Then grab and print the first 8-10(however many you want). Then you can do the same thing for an archives page - only skip the first 8-10 and then print the rest. Also, I believe it is better to setup your MySQL with 2 tables for articles - one with everything but the main text, and one with just the text and some ref to the other info in the first table. I believe it speeds up processing when searching etc. Not sure about the CMS stuff, just know I didn't use it for my personal page. Last edited by thecow; 06-03-2003 at 08:14 PM..