{"id":386,"date":"2010-10-18T05:49:35","date_gmt":"2010-10-18T13:49:35","guid":{"rendered":"http:\/\/s920040513.websitehome.co.uk\/?page_id=386"},"modified":"2010-10-18T05:49:35","modified_gmt":"2010-10-18T13:49:35","slug":"past-tours-shows","status":"publish","type":"page","link":"https:\/\/colinclyne.com\/?page_id=386","title":{"rendered":"Past Tours + Shows"},"content":{"rendered":"<h3>Past Tours+Shows<\/h3>\n<p>    <?php\n\n\t\t\/\/ Create the connection and select the DB\n\t\t$link = mysql_connect(\"localhost\",\"colinclyne\",\"bathurst57\");\n\t\t\n\t\tif ($link) {\n\t\t   mysql_selectdb(\"colinclyne\",$link);\n\t\t\n\t\t   \/\/ Select records from the DB\n\t\t   $query  = \"SELECT DATE_FORMAT(event_begin, '%b %d %Y'), event_desc, event_end, event_link, DATE_FORMAT(event_time, '%h:%i %p'), event_title FROM wp_calendar WHERE event_end <= DATE_SUB(CONCAT(CURDATE(), ' 00:00:00'), INTERVAL 1 DAY) AND event_category=2 ORDER BY event_begin DESC\";\n\t\t   $result = mysql_query($query);\n\t\t\n\t\t   \/\/ Display records from the table\n\t\t   echo \"\n\n<p class='TourList'>&#8220;;<br \/>\n\t\t   while ($row = mysql_fetch_array($result, MYSQL_NUM)) {<br \/>\n\t\t\t  $tdate = $row[0];<br \/>\n\t\t\t  $ttime = $row[4];<br \/>\n\t\t\t  $tdesc = $row[1];<br \/>\n\t\t\t  $ttitle = $row[5];<br \/>\n\t\t\t  $turl = $row[3];<\/p>\n<p>\t\t\t\techo &#8216;<\/p>\n<ul>\n<div class=\"tourdate\"><b>&#8216;.$tdate.&#8217; @ &#8216;.$ttime.&#8217; &mdash; &#8216;.$ttitle.&#8217;<\/b><\/div>\n<p>&#8216;;<br \/>\n\t\t\t\techo &#8216;<\/p>\n<li class=\"tourtitle\">&#8216;.$ttitle.&#8217;<\/li>\n<p>&#8216;;<br \/>\n\t\t\t\techo &#8216;<\/p>\n<li class=\"tourdesc\">&#8216;.$tdesc.&#8217;<\/li>\n<p>&#8216;;<br \/>\n                                echo &#8216;<\/ul>\n<p>&#8216;;<br \/>\n\t\t   }<br \/>\n\t\t   echo &#8220;<\/p>\n<p>&#8220;;<br \/>\n\t\t} else {<br \/>\n\t\t\techo &#8220;Can&#8217;t connect to the database!&#8221;;<br \/>\n\t\t}<br \/>\n\t\tmysql_close($link);<\/p>\n<p>\t?><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Past Tours+Shows<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"open","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"class_list":["post-386","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/colinclyne.com\/index.php?rest_route=\/wp\/v2\/pages\/386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/colinclyne.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/colinclyne.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/colinclyne.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/colinclyne.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=386"}],"version-history":[{"count":2,"href":"https:\/\/colinclyne.com\/index.php?rest_route=\/wp\/v2\/pages\/386\/revisions"}],"predecessor-version":[{"id":388,"href":"https:\/\/colinclyne.com\/index.php?rest_route=\/wp\/v2\/pages\/386\/revisions\/388"}],"wp:attachment":[{"href":"https:\/\/colinclyne.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}