รบกวนด้วยค่ะ ถ้าต้องการนำข้อมูลในฟิลด์วันเริ่มและวันสุดท้ายมาโชว์

CREATE TABLE `datetest` (
  `p_id` varchar(25) NOT NULL default '',
  `p_name` varchar(255) default NULL,
  `startdate` date default NULL,
  `enddate` date default NULL,
  PRIMARY KEY  (`p_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--------------

INSERT INTO `datetest` VALUES ('p_001', 'peak season', '2010-08-14', '2010-08-17');

SELECT * 
FROM datetest a 
WHERE 
	a.startdate <='2010-08-15' AND a.enddate >= '2010-08-17'

<?
		$date_begin="2010-08-05";
		$date_end="2010-08-10";
	    $show_date=(strtotime($date_end) - strtotime($date_begin))/(60*60*24);

for($i=0;$i<=$show_date;$i++)
  {
     echo date('Y-m-d',strtotime('+'.$i.' day',strtotime($date_begin)));
	 echo"<BR>";
  }

?>

$conn=@mysql_connect("localhost","root","root");
$db=@mysql_select_db("member");



mysql_query("CREATE  TEMPORARY TABLE calendar (c_date DATE);");
mysql_query("DELIMITER $$ ");
mysql_query("
							CREATE PROCEDURE sp_createcalendar()
							 BEGIN
								 DECLARE i INT DEFAULT 0 ;
								 DECLARE j INT DEFAULT 1 ;
								 DECLARE startdate DATE;
								 
								 SELECT CURDATE() INTO startdate;
								 SELECT DATEDIFF('2010-08-22',CURDATE()) INTO j;   
									  
								 WHILE i<=j DO
										INSERT INTO calendar SELECT DATE_ADD(startdate,INTERVAL i DAY); 
								 		SET i=i+1;
								 END WHILE;
								 
							END") ;
mysql_query("DELIMITER ;");
mysql_query("CALL sp_createcalendar();");


$query=mysql_query("SELECT * FROM calendar");
while($rs=@mysql_fetch_array($query))
{
	echo $rs["c_date"];
	echo "<br>";
}

mysql_query("DROP PROCEDURE IF EXISTS sp_createcalendar;");
mysql_query("DROP  TABLE IF EXISTS calendar;");