UK Webmaster Talk - Online Marketing - SEO


 

Am I able to fully automate my page?

This is a discussion on Am I able to fully automate my page? within the Php and MySQL forums, part of the Programming / Scripting / Coding category; I would like to know if I am able to set up a MySQL database for my news page and ...


Go Back   UK Webmaster Talk - Online Marketing - SEO > Website Design & Development > Programming / Scripting / Coding > Php and MySQL

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read

Notices

Reply

 

LinkBack Thread Tools Display Modes
Old 10-04-2007, 16:27   #1 (permalink)
Newbie
 
Join Date: Mar 2007
Posts: 12
iTrader: 0 / 0%
ShaunBurden is an unknown quantity at this point
Default Am I able to fully automate my page?

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?
ShaunBurden is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 10-04-2007, 17:58   #2 (permalink)
Super Moderator
 
Join Date: Mar 2005
Location: Herts, UK
Posts: 1,030
iTrader: 1 / 100%
monaghan is a jewel in the rough
Default

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.
monaghan is offline  
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

Tags
automate, fully, page

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads

Thread Thread Starter Forum Replies Last Post
Please critique my web page : ) ClockworkOrange Website Reviews 5 09-05-2007 13:15
Centering a page FrozenDice Website Development Forum 2 15-07-2005 17:42
Need help to fox a few bugs with my page vegancoder HTML, DHTML and CSS 1 25-06-2005 13:48
Photo Page woodflooristcom Search Engine Optimisation (SEO) 2 24-02-2005 17:36


All times are GMT +1. The time now is 17:41.


Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0
UK Webmaster Forum © WebmasterTalk.co.uk | Design by Forbairt

Ad Management by RedTyger

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41