Robert van Heumen Composer Improvisor Laptop-Instrumentalist Sound-Designer
Software Developer
Shackle Events
Selected Shackle concerts in the past and future
include '../inc/db-connect.php';
$query = "select title, date, text, id from events where hidden = 0 and (title like '%shackle%' or text like '%shackle%') order by date DESC";
$result = mysqli_query($conn, $query);
while($data = mysqli_fetch_row($result))
{
$day= substr($data[1],8,2);
$month = substr($data[1],5,2);
$year = substr($data[1],0,4);
$month_name = date("F", mktime(0, 0, 0, $month, $day, $year));
$day_number = date("j", mktime(0, 0, 0, $month, $day, $year));
$title = nl2br(strip_tags($data[0]));
$date_nice = $month_name.' '.$day_number.', '.$year;
$id = $data[3];
echo ''.$date_nice.' | '.$title.' |
';
}
include '../inc/db-disconnect.php';
?>