i have a database name movie and the fields are "datestart ", "dateended ". my problem is i want to retrieve the date that the movie is STARTED until the date that the movie is ENDED. example; date started is august 8, 2013, and the date ended is august 14, 2013 may concern is how to retrieve the date august 9, 2013, august 10, 2013 until august 13, 2013
// this is my code
<?php $q = mysql_query("select * from movie ");
$row = mysql_fetch_array($q);
$sdate=$row['datestart'];
$edate=$row['dateended'];
while($sdate<=$edate){
echo "<option value=$sdate>$sdate</datestart>";
$sdate=mktime(0,0,0,date("m"),(date("d")+1),date("Y"));
}
?>