Mysql Query Code Help.

[Hypersource]

heres my code:

 

 

 

$sql="

INSERT INTO `a8392424_pets`.`users` (

`user_id` ,

`user_name` ,

`user_pass` ,

`user_email` ,

`user_date` ,

`user_level` ,

`posts` ,

`married` ,

`cash` ,

`tokens`

)

VALUES (

NULL, '" . mysql_real_escape_string($_POST['user_name']) . "', '" . sha1($_POST['user_pass']) . "', '" . mysql_real_escape_string($_POST['user_email']) . "', NOW(),'0', 'noone', '10000', '10')";

$result = mysql_query($sql);

if(!$result)

{

//something went wrong, display the error

echo 'Something went wrong while registering. Please try again later.';

//echo mysql_error(); //debugging purposes, uncomment when needed

}

 

 

When I execute it, using my signup form, the query fails. my connection to database is GOOD.

Edited November 20, 2012 by Hypersource

[mrMarcus]

"the query fails" is quite vague.

 

Luckily, it's a simple fix. You have 10 `columns` to your 9 values to be inserted.

 

I would recommend using mysql_error(), y'know, for debugging purposes.

[play_]

As mrMarcus said.

 

user_id is probably an auto increment field, so you can delete the line

 

`user_id` ,

 

 

if it still doesn't work, uncomment

 

"//echo mysql_error(); //debugging purposes, uncomment when needed".

and comeback with a decent error message.

 

it even says right there. "debugging purposes. uncomment when needed".

Edited November 20, 2012 by play_

[Hypersource]

Thanks but I just now realized that the "posts" field had nothing included. Thanks for telling me about the mysql error thing. Thanks SO much!!