SHOW:
|
|
- or go back to the newest paste.
| 1 | <html> | |
| 2 | <style> | |
| 3 | html{
| |
| 4 | font-family: arial; | |
| 5 | } | |
| 6 | </style> | |
| 7 | <h1>Local Events</h1> | |
| 8 | <hr> | |
| 9 | <br> | |
| 10 | <?php | |
| 11 | //mysql connection | |
| 12 | mysql_connect('localhost', 'root', '') OR DIE ("Unable to connect to database! Please try again later.");
| |
| 13 | ||
| 14 | //selecting the table | |
| 15 | mysql_select_db('local');
| |
| 16 | ||
| 17 | //query | |
| 18 | $query = mysql_query("SELECT *, CONCAT(DATE_FORMAT(date_start, '%M %d'),(IF(date_start = date_end,'',CONCAT(' - ', DAY(date_end)))))
| |
| 19 | newDate FROM events3 WHERE date_end >= CURDATE() ORDER BY date_start LIMIT 5"); | |
| 20 | ||
| 21 | //CONCAT(DATE_FORMAT(date_start, '%M %d'), ' - ', DAY(date_end)) newDate and in your php $dateSched = $rows['newDate']; echo "<b>Date Start:</b> "; echo $dateSched; | |
| 22 | ||
| 23 | //SELECT * FROM events3 WHERE date_end >= CURDATE() ORDER BY date_start LIMIT 5; ::BEST ONE!! | |
| 24 | ||
| 25 | //http://stackoverflow.com/questions/2597098/get-the-last-n-rows-in-the-database-in-order | |
| 26 | //SELECT * FROM events ORDER BY date_start DESC LIMIT 5 ::Works but still need to reverse order | |
| 27 | //SELECT * FROM events ORDER BY id DESC LIMIT 5; | |
| 28 | //SELECT * FROM events ORDER BY id DESC LIMIT 5; | |
| 29 | //WHERE year = '2012' | |
| 30 | ||
| 31 | //fetch results | |
| 32 | ||
| 33 | WHILE($rows= mysql_fetch_array($query)): | |
| 34 | ||
| 35 | $id = $rows['id']; | |
| 36 | $title = $rows['title']; | |
| 37 | $admission = $rows['admission']; | |
| 38 | ||
| 39 | $date_start = $rows['date_start']; | |
| 40 | $date_end = $rows['date_end']; | |
| 41 | $dateSched = $rows['newDate']; | |
| 42 | ||
| 43 | $time_start = $rows['time_start']; | |
| 44 | $time_end = $rows['time_end']; | |
| 45 | ||
| 46 | $location = $rows['location']; | |
| 47 | $description = $rows['description']; | |
| 48 | $image = $rows['image']; | |
| 49 | $hyperlink = $rows['hyperlink']; | |
| 50 | ?> | |
| 51 | <?php | |
| 52 | //ID/ Title Display | |
| 53 | //echo "<b>ID:</b> "; echo "$id<br>"; | |
| 54 | echo "<b>Title:</b> "; echo "$title<br>"; | |
| 55 | if ($admission == null ){
| |
| 56 | echo " "; | |
| 57 | }else{
| |
| 58 | echo "<b>Admission:</b>  "; echo "$admission<br>"; | |
| 59 | } | |
| 60 | ||
| 61 | //Date Display | |
| 62 | echo "<b>Date Start:</b> "; | |
| 63 | echo "$dateSched<br>"; | |
| 64 | //echo "$date_start"; echo ' - '; echo "$date_end<br>"; | |
| 65 | ||
| 66 | //Time Display | |
| 67 | echo "<b>Time Frame:</b> "; | |
| 68 | echo date('g:i a',strtotime($time_start)); echo" - "; echo date('g:i a',strtotime($time_end)); echo"<br>";
| |
| 69 | // echo "$time_start"; echo " - "; echo "$time_end<br>"; | |
| 70 | ||
| 71 | ||
| 72 | echo "<b>Location:</b> "; echo "$location<br>"; | |
| 73 | echo "<b>Description:</b> "; echo "$description<br><hr><br>"; | |
| 74 | ||
| 75 | ||
| 76 | ||
| 77 | endwhile; | |
| 78 | // SELECT * FROM events ORDER BY id DESC LIMIT 10; | |
| 79 | ?> | |
| 80 | ||
| 81 | </html> |
