Advertisement
dpnash

iCal from PHP - MySQL test

Apr 30th, 2013
343
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. <?php
  2.  
  3. $query = "SELECT eventDate, eventStart, TIME_FORMAT(eventStart, '%l:%i %p') as starttime, TIME_FORMAT(eventEnd, '%l:%i %p') as endtime, eventName,
  4. hotelSpace, eventDescription
  5. FROM events WHERE eventDate='2012-5-23' ORDER BY eventStart";
  6. $result = @mysql_query ($query);
  7. if ($result) {
  8.  
  9. while ($row = mysql_fetch_assoc ($result)) {
  10. echo '<tr>
  11. <td align="left">' . $row['starttime'] . ' - ' . $row['endtime'] . '</td>
  12. <td align="left">' . $row['eventName'] . '</td>
  13. <td align="left">' . $row['hotelSpace'] . '</td>
  14. <td align="left">' . $row['eventDescription'] . '</td></tr>';
  15. <td align="left">' CODE TO CREATE ICAL DOWNLOAD GOES HERE '</td></tr>';
  16. }
  17. echo '</table>';
  18. }
  19.  
  20. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement