This example describes using PHP to connect to a MySQL Database.

<%

//Connect To Database

$hostname="127.0.0.1";
$username="db_username";
$password="db_password";
$dbname="db_name";

mysql_connect($hostname,$username, $password);
mysql_select_db($dbname);

# Check If Record Exists

$query = "SELECT * FROM $usertable";

$result = mysql_query($query);

if($result)
{
while($row = mysql_fetch_array($result))
{
$name = $row["$yourfield"];
echo "Name: ".$name."
";
}
}
?>