ShaunBurden

I would like to know if I am able to set up a MySQL database for my news page and only have to update one field, so that I can have four fields, and when the first one is updated all the data gets moved down one.

Here's an example. Say I have a field called LNews(Latest News) and three called PNews, PNews1 etc to PNews3. Lets say that I currently have text in LNews, but now I have a newer article which will replace this one, I would like to put this new text into LNews, and then have the text that is currently in LNews put into PNews1, and so on, so that the text that is in PNews3 will be replaced with PNews2, and all I have to do is update LNews and the rest will be taken care of.

Is this possible?

monaghan

Select your news by date and limit to 4 records

Populate LNews with record1, PNews with record 2, Pnews2 with record 3 pnews3 with record 4.

When you add a new record it will be a later date and everything will pop into the right place next time the news page is processed.

__________________
Alex Monaghan - Monaghan Consultants Ltd
Web hosting, ADSL, IT & Database consultancy
Custom Web hosting on UK or USA servers using Linux (cPanel) or Windows (DotNetPanel)
Mobile Phone Ringtones, Logos, Java Games & more