Displaying Dates

[bjblackmore]

Hi,
I have 2 dates stored in a mysql database. Start and End. Stored as timestamp(8) i.e. 20011116.
I want to print every day between 'start' and 'end' so i did
while ($start =< $end){
echo $start;
start++;
}

Which works ok if the dates are like 1st - 10th or something, just if its 1st november - 1st december, it prints 1 - 100. Rather than 1 - 30. How do I tell it I want to count upto the number of days in that month. i.e. 1 - 30 november.
Cheers
Ben

[[deleted]]

rasd about mktime(). It lets you create a timestamp (a real one, not that fake MySQL stuff) for dates like Jan 254th 2001.
Then you can use date() to make a printable string.

[bjblackmore]

I've tried

$query = "SELECT status,start_date,end_date FROM availability WHERE user_id='113'";
$result=db_query($query);
while($row=mysql_fetch_array($result)){
$start = $row['start_date'];
$end = $row['end_date'];
$syear=substr($start, 0, 4); $smonth=substr($start, 4, 2); $sday=substr($start, 6,2);
$smktime = mktime("","","","$smonth","$sday","$syear");
$sdate = date ("dmY",$smktime);
$eyear=substr($end, 0, 4); $emonth=substr($end, 4, 2); $eday=substr($end, 6,2);
$emktime = mktime("","","","$emonth","$eday","$eyear");
$edate = date ("dmY",$emktime);

while($sdate <= $edate){
echo "<tr><td><font face=$font color=green>$sdate</font></td>";
}
$sdate++;
}

But it seems to just add +1 to the year.
Ben

[jesus_hairdo]

i would think the best way to store the dates would be as the unix time stamp, so instead of having a date field in mysql have a numerical field.

for ($i = start; $i <=$end; $i = $i + 86400)
{
$temp = date("dmY",$i)
print $temp;
}

( i think that the 86400 number is right (its the number of seconds in a day, or should be!))

[bjblackmore]

I have it stored as a timestamp(8) and I can get it to print the days if its 19th Nov - 30th Nov. But If its 19th Nov - 19th Dec it print to 100 days in november, then to 19th december.
I just want it to do 19th - 30th, then 1st - 19th.
Ben

[jesus_hairdo]

i think that all of your making up of the dates is unnecessary, all you need to do as in my exam is to do a date("dmY",$date) to output the 1st date, then increase the value of $date by the number of seconds in a day 86400 then date("dmY",$date) will return the date on the next day.
i have just tested my example and it does indeed work as you wanted.

[[deleted]]

Use SQL's unix_timestamp() http://www.mysql.com/doc/D/a/Date_and_time_functions.html to try to convert the 'timestamp' you have in the database to something that PHP will understand.

Then FORGET all about substings and all that sh*t. Dump the value from MySQL straight into date() and add X seconds untill you are at the value of the second timestamp.

Should work.

A few notes:
NEVER EVER quote variables, especiallty not in a function call when the value you are using is an intereger in the first place, and always put just one PHP command on each line.