mysql insert not working

[ess14]

can anyone tell me why the following code isnt working?

 

$sql = mysql_query("INSERT INTO users (tracknum, username, address, state, city, phone, fax, email, groupn, isdone) VALUES('$tracknum', '$username', '$address', '$state', '$city', '$phone', '$fax', '$email', '$groupn', '$isdone')")  or die (mysql_error());

 

I know all the variables exist before that statement.

Is there anything else it can be? Im not getting any error codes or anything. only this...

 

if(!$sql){

    echo 'There has been an error creating your account.';

}

 

Has anyone got any ideas of what it could be or how to get some more useful error messages?

[Shazbot!]

I am assuming that this is a MSSQL server you are connecting to so you need to change the mysql to mssql.

You can also try to remove the () for the column names

 

INSERT INTO users tracknum, username, address, state, city, phone, fax, email, groupn, isdone VALUES ('$tracknum', '$username', '$address', '$state', '$city', '$phone', '$fax', '$email', '$groupn', '$isdone')") 

 

finally, if any of your fields are of type int then you will need to remove the ' ' for the values.