[SOLVED] Whats wrong with this MySQL

[Vivid Lust]

Hi, I'm new to MySQL and was just wondering what im doing wrong with this query:

 

<?php
       $unkn = "unknown";
        $zero = "0"; 
        $user = mysql_query("
        INSERT INTO `users` (
`email`,
`pass`,
`name`,
`gender`,
`location`,
`about`,
`s_phish`,
`u_phish`,
`p_phish`,
`p_s`,
)
VALUES (
\"$email\", \"$pass\", \"$name\", \"$unkn\", \"$unkn\", \"$unkn\", \"$zero\", \"$zero\", \"$zero\", \"$zero\"
)

        ")
        or die("could not execute insert query");
?>
[code]

It keeps on dying  

The previous variation worked:

[code]
$user = mysql_query("
        INSERT INTO `users` (
`email` ,
`pass` ,
`name`
)
VALUES (
\"$email\", \"$pass\", \"$name\"
)

        ");

 

But not this one... any help really appreciated [/code][/code]

[fenway]

Until you echo that query in plaintext, we can't possibly know.

[Vivid Lust]

I get:

 

INSERT INTO `users` ( `email`, `pass`, `name`, `gender`, `location`, `about`, `s_phish`, `u_phish`, `p_phish`, `p_s`, ) VALUES ( "", "", "", "unknown", "unknown", "unknown", "0", "0", "0", "0" )

 

 

Spaces are where variables are which do work, so i suspose they dont really matter at the moment.

[toplay]

Remove the comma after p_s column.

 

Change this:

 

`p_s`, )

 

to this:

 

`p_s`)