Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $query = "SELECT eventDate, eventStart, TIME_FORMAT(eventStart, '%l:%i %p') as starttime, TIME_FORMAT(eventEnd, '%l:%i %p') as endtime, eventName,
- hotelSpace, eventDescription
- FROM events WHERE eventDate='2012-5-23' ORDER BY eventStart";
- $result = @mysql_query ($query);
- if ($result) {
- while ($row = mysql_fetch_assoc ($result)) {
- echo '<tr>
- <td align="left">' . $row['starttime'] . ' - ' . $row['endtime'] . '</td>
- <td align="left">' . $row['eventName'] . '</td>
- <td align="left">' . $row['hotelSpace'] . '</td>
- <td align="left">' . $row['eventDescription'] . '</td></tr>';
- <td align="left">' CODE TO CREATE ICAL DOWNLOAD GOES HERE '</td></tr>';
- }
- echo '</table>';
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement