so I've this code

`$sql = "INSERT INTO userTable (username, password, gender, city, zip, email) VALUES ('$username', '$password', '$male', '$city', '$email')";
mysql_query($sql) or die ("unable to process query");`

and for whatever reason it creates my local server but this is not on the webserver, all of the variables are positioned without a doubt. it provides me with the not able to process query error,

shall we be held doing something clearly wrong? thanks

You are supplying 6 parameters, only 5 values inside your place statement.

do this

$sql = "INSERT INTO userTable (username, password, gender, city, zip, email) VALUES ('$username', '$password', '$male', '$city', '$zip', '$email')"; mysql_query($sql) or die ("unable to process query");

ScArcher appears to possess found the right answer, but you could also need to know about mysql_error. This can be used to print the mistake in the database, so the next time you are able to possibly solve the mistake yourself.

$gender is missing