Posted by pauld on 04/01/06 11:28
thank you . I also need to use the date format as a lookup in an sql
query
end result that works
$date=("now");
$enddate=strtotime($date);
//print he dates from start date to present
for ( $dl=strtotime($l['cc_startdate']) ;$dl < $enddate ;
$dl=$dl+24*60*60)
//for ($dl=$l['cc_startdate'];$dl < $enddate;$dl++)
{$dlookup=date('Y-m-d',$dl);
//////////////////cell for date
print '<tr><td>'.$dlookup.'</td>';
print '<td>';
{
$sql2='SELECT * FROM table WHERE date=\''.$dlookup.'\'';
etc
Navigation:
[Reply to this message]
|