Swapping Items In A Table
Here's a query that all you novice's will most certainly will be able to solve.
I was building a website for my dad and then I got thinking, what if I wanted to do this for a living?
So I started messing around, and this popped into my head, and I cannot figure out how to solve it!
I want to swap information saved in MYSQL database every hour.
For example, in the first hour 'blurb 1' will show, then, at the strike of the hour, 'blurb 2' will show, and the same thing happens until the table is empty.
So basically I need the coding to swap this information, but after each piece blurb has been showed, I want it deleting from that table.
Any chance of a hand guys?