View All Upcoming

$query = "SELECT todo_id, title, date, done, details, datedue FROM todo WHERE done='0000-00-00' ORDER BY datedue ASC";

$result = mysql_query ($query);

while ($row = mysql_fetch_array($result))

{

$todo = $row['todo_id'];
$title = $row['title'];

$date = $row['date'];

$done = $row['done'];

$details = $row['details'];

$datedue = $row['datedue'];

echo '

‘;
echo ‘

Title: ‘ . $title . ‘

‘;

echo ‘

Date Posted: ‘ . $date . ‘

‘;

echo ‘

Date Due: ‘ . $datedue . ‘

‘;

if ($done == ’0000-00-00′)
{
echo ‘

Done Yet? No

‘;
}
else{
echo ‘

Date Completed: ‘.$done.’

‘;
}

echo ‘

Details: ‘ . $details . ‘

‘;
echo ‘

‘;
// echo $title;

}

?>