// connect to mySQL and if not pass back an error
$connection = mysql_connect($sql_host, $sql_username, $sql_password); $error = mysql_error();
if (!$connection) { sql_error("Unable to connect with your login info for MySQL. Reason: $error", $connection); }
if ($debug) { echo "Host connection established....<BR>"; } //a little something for debugging

// now we need to connect the database
$db = mysql_select_db($sql_database, $connection); $error = mysql_error();
if (!$db) { sql_error("Unable to connect to database. Reason: $sql_username $sql_database $error", $connection); }
if ($debug) { echo "Database connection established....<BR>"; } // a little debugging info if needed...


// run the query to update the 'sales' column...
$query = "SELECT * FROM Users WHERE Username = '$Username'";
$result = mysql_query($query); if (!$result) { $error = mysql_error(); sql_error("Unable to login...Reason: $error", $connection); }
mysql_query($query);

// if we get a SQL error, put it here
function sql_error($error, $connection) {

$template = file("signup_error.html");

foreach ($template as $line) {

$line = ereg_replace("::ERROR::", "$error", $line);
echo $line;

}

mysql_close($connection); // exit the connection so we dont clog up MySQL
exit;

}