<?PHP
require('dblink.php');
//mysql query
$query = 'INSERT INTO member (Username, Password, Email Address, First Name, Last Name, Sex, Date of Birth, City, Country) VALUES ("'.$_POST[Username].'", "'.$_POST[Password].'", "'.$_POST[Email].'")';
$db_query = mysql_query($query);
$to = $_POST['Email'];//the email address the user submitted
$subject = 'You Registered!';
$message = 'You have just registered to play on The Streets. To log in go to the main page and use your username and password to sign in.';//the body of the email you are sending
mail($to, $subject, $message);//mail sent
?>
sorry for asking so many questions about mysql, im very new to it.
The first column in a table is usually an index||key. I think this is what it is refering to... PHPMyAdmin doesn't like the fact that you haven't defined one for your table.