Slet feks billeder fra dato til dato

$sql = "DELETE FROM billeder WHERE dato < DATE_SUB(NOW(), INTERVAL 7 DAY) AND solgt_antal > min_solgt";

$sql = "DELETE FROM billeder WHERE dato < DATE_SUB(NOW(), INTERVAL 7 DAY AND solgt_antal > min_solgt";

CREATE TABLE IF NOT EXISTS `tbl_billeder` (
`billedid` int(10) NOT NULL,
  `arkiv` varchar(255) CHARACTER SET utf8 COLLATE utf8_danish_ci NOT NULL,
  `billednavn` varchar(255) CHARACTER SET utf8 COLLATE utf8_danish_ci NOT NULL,
  `solgt` int(5) DEFAULT NULL,
  `dato` date NOT NULL,
  `tid` time DEFAULT NULL,
  `solgtdato` date DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 CHECKSUM=1;

--
-- Data dump for tabellen `tbl_billeder`
--

INSERT INTO `tbl_billeder` (`billedid`, `arkiv`, `billednavn`, `solgt`, `dato`, `tid`, `solgtdato`) VALUES
(1, '', 'dummy1', 5, '2015-03-24', '12:00:00', '2015-04-15'),
(2, '', 'dummy2', 2, '2015-03-24', '12:00:00', '2015-04-15');

  
DELETE FROM tbl_billeder WHERE DATE(dato) < DATE(DATE_SUB( NOW(), INTERVAL 7 DAY) ) AND (solgt> 3); 

DELETE FROM billeder WHERE DATE(dato) < DATE(DATE_SUB( NOW(), INTERVAL 7 DAY) ) and dato >'00:00:00'; 

SELECT billedid, billednavn FROM billeder WHERE DATE(dato) < DATE(DATE_SUB( NOW(), INTERVAL 7 DAY) ) and dato >'00:00:00

$sql = "SELECT billedid, billednavn FROM billeder WHERE DATE(dato) < DATE(DATE_SUB( NOW(), INTERVAL 7 DAY) ) and dato >'00:00:00";
loop begin
unlink($row['billednavn']);
$sql1 = "DELETE FROM billeder WHERE billedid = $row['billedid']";
loop end