[mhutti1]

This code for creating users does not work

PHP Code:

$connect5=mysql_connect("SERVER","USERNAME","PASSWORD") or die ("Could not connect to database");

mysql_select_db("DATABASE") or die ("Could not find database");

$query10 = mysql_query("INSERT INTO members VALUES ('','$username','$enc_password','$name','Private')") or die("error"); 


It seems to connect fine however the insert into statement triggers the error message and consequently no user is created. Does anyone know why this is?

[d3iti]

Hello,

Your members table have EXACTLY 5 fields? If it have not exactly 5 fields you can not use the short form for INSERT.

In PHP variables, are you used in your SQL query is there any value?

Try to modify the end of your statement to see if MySQL will return an error:

PHP Code:

$query10 = mysql_query("INSERT INTO members VALUES ('','$username','$enc_password','$name','Private')") or die("Error:" .mysql_error()); 


[mhutti1]

I had just added an extra field to my table so there were 6 fields not 5. Thanks very much for the help I altered the code and now it works.