Hi Craig, this is very kind of you. I'll leave it here as it may be useful to others.
The table does NOT have a date. These will just a a selection of top ten items (like cars, or albums, or whatever). A date isn't necessary (for the list)
This is the MySql dump
-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 19, 2010 at 07:03 PM
-- Server version: 5.1.36
-- PHP Version: 5.2.9-2
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `cvmorguk`
--
-- --------------------------------------------------------
--
-- Table structure for table `toptenlist`
--
CREATE TABLE IF NOT EXISTS `toptenlist` (
`topTenListID` int(9) NOT NULL AUTO_INCREMENT,
`1` varchar(50) NOT NULL,
`2` varchar(50) NOT NULL,
`3` varchar(50) NOT NULL,
`4` varchar(50) NOT NULL,
`5` varchar(50) NOT NULL,
`6` varchar(50) NOT NULL,
`7` varchar(50) NOT NULL,
`8` varchar(50) NOT NULL,
`9` varchar(50) NOT NULL,
`10` varchar(50) NOT NULL,
`Image` varchar(100) NOT NULL,
`Active` int(1) NOT NULL,
PRIMARY KEY (`topTenListID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `toptenlist`
--
INSERT INTO `toptenlist` (`topTenListID`, `1`, `2`, `3`, `4`, `5`, `6`, `7`, `8`, `9`, `10`, `Image`, `Active`) VALUES
(1, 'Mazda MX-5L', 'Toyota MR2 (Mk1)', 'Subaru Impreza WRX', 'Peugeot 205 GTI', 'Nissan 200 SX', 'Mini Cooper S (not BMW!)', 'Renault Clio Williams ', 'Lotus Elan', 'Ford Focus ST170', 'VW Golf GTI', 'budget_fast_cars.jpg', 2);
I have got the "Active" field in there but don't really want to use that unless there is no other way.
So the result of this would be someone visiting the site this week would see a list of cars, next week a list of albums the week after a list of whatever and so on.
Is that more helpful?