';
// Connect to the Database
$link = mysql_connect($host, $user, $password) or die('Euuurgh!: Could not connect: ' .mysql_error());
echo 'Connected to database '.$database.' successfully'.'';
// Select The Database
mysql_select_db($database) or die('Could not select database');
// Perform a Simple SQL query
$result = mysql_query($query) or die('Query failed: ' . mysql_error());
echo "Query on ".$table." succeeded";
// Printing results in HTML
echo "
\n";
while ($line = mysql_fetch_array($result, MYSQL_ASSOC))
{
echo "\t\n";
foreach ($line as $col_value)
{
echo "\t\t| $col_value | \n";
}
echo "\t
\n";
}
echo "
\n";
// Free resultset
mysql_free_result($result);
// Closing connection
mysql_close($link);
?>