PHP/MySQL Database Error

[shreydesai]

With Dreamweaver and PHP, I am trying to use an HTML form that I created to add tables to my MySQL database, but it's just not adding! The MySQL Database is called 'login' and the table is called 'users', and here is the code I put into Dreamweaver:

$query = mysql_query("INSERT INTO users VALUES ('','$name','$username','$enc_password')")

Any suggestions?

 

[ct2k7]

Use this syntax, it's clearer:

INSERT into USERS ('ID','name','username','password') VALUES (NULL,'$name','$username','$enc_password')

I do hope that you are escaping each string using mysql->real_escape_string.

I also suggest you use mysqli over mysql.

maybe you can tell us more if there are any error using:

$query = mysql_query("INSERT into USERS ('ID','name','username','password') VALUES (NULL,'$name','$username','$enc_password')") or die(mysql_error());

I have assumed that the first field is an ID field.