Clubs and Associations

//include 'dbase_config.php';
//include 'dbase_connect.php';

// ... do something like insert or select, etc
$query = "SELECT id, name, contact, title, street, region, telephone, email FROM clubs order by name ASC";
$result = mysql_query($query);
while($row = mysql_fetch_row($result))
{
$id = $row[0];
$name = $row[1];
$contact = $row[2];
$title = $row[3];
$street = $row[4];
$region = $row[5];
$telephone = $row[6];
$email = $row[7];

$name = str_replace (";", "
“, $name);
$contact = str_replace (”;”, “
“, $contact);
$title = str_replace (”;”, “
“, $title);
$telephone = str_replace (”;”, “
“, $telephone);
$email = str_replace (”;”, “
“, $email);

echo “

“;
if (!$email == “”){

echo “

“;
}
else {
echo “

“;
}
echo “

“;
}
//mysql_close ($clubsconn)
?>