<?php
$dns="GunzDB";
$user="sa";
$pass="password";
$connect=odbc_connect($dns, $user, $pass) or die ("Couldn't connect to the database, we're sorry...");
odbc_exec($connect,"use GunzDB");

//get latest clan fight
$query = odbc_exec($connect, "SELECT * FROM Clan WHERE RegDate = (SELECT MAX(RegDate) FROM Clan)");
odbc_fetch_row($query);
$name = odbc_result($query, "Name");

//writing the results to the screen
echo "Newest Clan: <b>".$name."</b>";
?>