Here's all the code that I have and some screen shot that I have the database from phpMyAdmin:
admin/index.php
PHP Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Admin Login</title>
</head>
<body>
<?php
include 'config.php';
?>
<form action="<?php echo ($_SERVER['PHP_SELF']); ?>" method="get">
<!-- not yet implemented -->
</form>
</body>
</html>
admin/config.php
PHP Code:
<?php
$username = 'username'; // MySQL username
$password = 'password'; // MySQL password
$host = 'localhost'; // MySQL host
$db = 'webtest'; // Database name
$link = mysql_connect($host,$username,$password) or die(mysql_error());
mysql_select_db($db); // Select database
// MySQL Query
$query = 'CREATE TABLE mycms ('.
'id INT NOT NULL AUTO_INCREMENT KEY'.
'username VARCHAR(10) NOT NULL, '.
'password VARCHAR(10) NOT NULL)';
$result = mysql_query($query);
?>
webtest database from phpMyAdmin
*attached*