not quite sure what you mean by "weeknum would need to appear on 2 or more occasions"
weekNum would be a column in the table, using the SQL data dump that john provided:
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,
`weemNum` int(4) 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`, `weemNum`) 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, 20);
your just adding the weekNum column at the end and giving it a value of 20.
change the original query to:
SELECT *
FROM toptenlist
WHERE weekNum = DATE_FORMAT(CURDATE(),'%v')
ORDER BY topTenListID ASC
no need for a stored procedure.
