Wareham Town Meetings:
[insert_php]
$link = mysqli_connect(“localhost”,”vod”,”camera@ction505!”,”vod”) or die(“Error ” . mysqli_error($link));
$query = “SELECT id, name, month, day, year, episode FROM video WHERE name = ‘Town Meeting’ ORDER BY year DESC, str_to_date(month,’%M’) DESC, day DESC”;
$result = $link->query($query);
while($row = $result->fetch_array())
{
$rows[] = $row;
}
foreach($rows as $row)
{
$id=$row[‘id’];//Get the id to add to URL to pass to next script when URL is clicked
echo (““. $row[‘name’].”: “. $row[‘episode’].””. $row[‘month’].””.$row[‘day’].”, “. $row[‘year’].”
“);
}
/* free result set */
$result->close();
/* close connection */
$link->close();
[/insert_php]