This is how I would do it personally:
Assuming the following table columns:
title = title of the event
desc = description of the event
streetaddy = street address
city = uh city
state = do I really need to say
zip = yeah if you don't get it by now....
<?php
$result = mysql_query('
SELECT title, `desc`, streetaddy, city, state, zip
FROM events');
if (!$result)
die('Oh fuck');
if (mysql_num_rows($result) == 0)
{
echo '<div>No events</div>';
return;
}
echo '
<dl>';
while ($event = mysql_fetch_assoc($result))
{
echo '
<dt>', $event['title'], '</dt>
<dd class="description">', $event['desc'], '</dd>
<dd class="location">
', $event['streetaddy'], '
', $event['city'], ', ', $event['state'], ' ', $event['zip'], '
</dd>';
}
echo '
</dl>';
mysql_free_result($result);
?>
Then use CSS to make it look pretty (like using pre formating on the address)