This is my register.php code. when i click register thisshows you account created sucessful but when i go to database nothing there?
i dont understand
<html>
<title></title>
<body>
<center><img src="http://.photobucket.com/albums/ii513//Untitled-4.jpg" border="0" alt=".com"></a></center>
<head>
<style type="text/css"><!--
body {scrollbar-3dlight-color:silver;
scrollbar-arrow-color:white;
scrollbar-track-color:black;
scrollbar-darkshadow-color:gray;
scrollbar-face-color:gray;
scrollbar-highlight-color:gray;
scrollbar-shadow-color:black}
body { background-color:#404040; }
--></style>
</head>
</html>
<p><?php echo date("F j, g:i:s a"); ?></p>
<?php
echo "<h3>Register here for free account</h3>";
$submit = $_POST['submit'];
//form data
if ($_POST['submit'])
{
$username = strip_tags($_POST['username']);
$password = md5(strip_tags($_POST['password']));
$repeatpassword = md5(strip_tags($_POST['repeatpassword']));
echo $username;
error_reporting(0);
require "connect.php";
$write = mysql_query("INSERT INTO mysql_xxxxxxxxx VALUES('username','password')");
echo"<p><b>Account created sucessful</b>";
}
?>
<html>
<form action='register.php' method='POST'>
<table>
<tr>
<td>
Choose a username:
</td>
<td>
<input type='text' name='username'>
</td>
</tr>
<tr>
<td>
Choose a Password:
</td>
<td>
<input type='password' name='password'>
</td>
</tr>
<tr>
<td>
Repeat Password:
</td>
<td>
<input type='password' name='repeatpassword'>
</td>
</tr>
</table>
<p>
<left><input type='submit' name='submit' value='Register'>
</form
<p><a href='index.html'><u><b>Back to log in page</b></u></a></p>
</html>
this is my connect.php
<?php
$connect = mysql_connect("xxxxxxxx", "xxxxxxxx", "xxxxxxxx") or die ("Couldnt connect");
mysql_select_db("xxxxxxxxl") or die ("Couldnt find database");
echo "connection successful";
?>