
|
 |

Date:
|
Time:
|
Location:
|
Comments:
|
include '.mysql';
$link = mysql_connect($host, $user, $pass) or die("Could not connect");
mysql_select_db($db, $link) or die("Could not select database");
$sql = "SELECT DATE_FORMAT(day, '%W, %M %e') AS date, DATE_FORMAT(day, '%j') AS day_order, ";
$sql .= "DATE_FORMAT(day, '%l:%i %p') AS time, location, comments, url FROM gigs ORDER BY day_order";
$result = mysql_query ($sql) or die ("Could not select gigs -- ".mysql_error());
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
?>
echo $row['date']; ?> |
echo $row['time']; ?> |
if($row['url'] != "") { echo "".stripslashes($row['location']).""; }
else { echo stripslashes($row['location']); }
?>
|
echo stripslashes($row['comments']); ?> |
}
mysql_free_result($result);
mysql_close($link);
?>


|
 |