I'm working on a PHP snippet... as you can see I have it so the stuff that is concidered new news is younger than 30 days and anything thats old news will be moved to the old news section once it has surpassed 30 days.if($_GET['type']=='latest'){
$where="CREATION_DATE > DATE_SUB(NOW(), INTERVAL 30 DAY)";
}elseif($_GET['type']=='old'){
$where="CREATION_DATE < DATE_SUB(NOW(), INTERVAL 30 DAY)";
My quesiton is, how do I make is so that no matter what the creation date, I'll always have 2 items in the new news and the rest of the items in the old news sections.
Any bit of info will help me out.
or even possibly... have all the news under 30 days in the new news then moved to the old news once it has surpassed 30 days but make sure to leave at least 4 items remaining even if they are out of date if nothing else has been posted... I appreciate any help I can get and hope I posted this in the right spot.
