= NOW() - INTERVAL 30 DAY and
STR_TO_DATE(( CONCAT(month_release, date_release, year_release)),'%m %d %Y')< NOW() - INTERVAL 7 DAY
order by
STR_TO_DATE(( CONCAT(month_release, date_release, year_release)),'%m %d %Y')
desc limit 7") or die(mysqli_error($con));
//$sql1=mysqli_query($con,"SELECT * FROM film WHERE release_date >= NOW() - INTERVAL 30 DAY and release_date< NOW() - INTERVAL 7 DAY order by release_date desc limit 7");
while ($row1 = mysqli_fetch_array($sql1)) {
$fname1 = strtolower(str_replace(" ", "-", $row1['name']));
$fname11 = preg_replace("/[^a-zA-Z0-9-]/", "", $fname1);
?>
= NOW() - INTERVAL 21 DAY and
STR_TO_DATE(( CONCAT(month_release, date_release, year_release)),'%m %d %Y')< NOW()
order by
STR_TO_DATE(( CONCAT(month_release, date_release, year_release)),'%m %d %Y')
desc limit 7") or die(mysqli_error($con));
//$sql1=mysqli_query($con,"SELECT * FROM film WHERE release_date >= NOW() - INTERVAL 30 DAY and release_date< now() order by release_date desc limit 7");
while ($row1 = mysqli_fetch_array($sql1)) {
$fname1 = strtolower(str_replace(" ", "-", $row1['name']));
$fname11 = preg_replace("/[^a-zA-Z0-9-]/", "", $fname1);
?>
