Hey I am working on a PHP calendar here, and I am pretty new to this all but so far everything works except when I try to retrieve my data from my database it only shows one entry at a time instead of listing ALL of the current items in the database. I hope that makes sense. Thank you, here is my code:
<?php
foreach ($activities as $activity)
{
date("F j, Y, g:i a", $activity['event_timestamp_1']);
'<option value="'.$activity['id'].'">'.$activity['event_title'].'</option>';
"\n";
}
{
date("F j, Y, g:i a", $activity['event_timestamp_2']);
'<option value="'.$activity['id'].'">'.$activity['event_title'].'</option>';
"\n";
}
?>
<?php
$result = sqlQuery('SELECT * FROM activities ORDER BY event_timestamp_1 DESC');
$activities = $result['data'];
foreach ($activities as $activity)
?>