Problem on the insert

[Anon]

<?php

if ($submit) {
if (!$username || !$password || !$email) {
$error = '<p class=text>Du kan i det minste fylle ut alle feltene</p>';

} else {

	$checkuser=mysql_query("SELECT username FROM members WHERE username='$username'",$db);
	if (mysql_num_rows($checkuser) == 0) {
		$error = '<p class=text>Brukernavnet er dessverre opptatt</p>'; exit;
	} else {
			INSERT INTO members (username,password,email) VALUES ('$username','$password','$email',);
		mail($email, "Velkommen, $username, du er nå medlem av Zkole.com", "Ditt brukernavn er $username<br>Ditt passord er $password);
		echo "<p class=text>Takker så meget. En epost har blitt sendt til din adresse som forteller deg hvordan du tar i bruk din nye Zkole.com-konto</p>";
	}	

}

if (!$submit || $error) {

echo $error;

?>

The INSERT line makes an error. Christ I don't know what the heck I'm doing wrong here.

[marcel]

Probably you want someting like:

$insertQuery="INSERT INTO members (username,password,email) VALUE('$username','$password','$email',)";
mysql_query($insertQuery, $db);

[steved]

You need to get rid of the comma after your '$email' variable. It should look like:

INSERT INTO members (username,password,email) VALUES ('$username','$password','$email');