[SOLVED] mysql query issues

[thefortrees]

Hi all - this insert query isn't working. I'd appreciate a second pair of eyes to check it over and see if there is anything I missed. Thanks!

 

if ( empty($message) ){
		$query = "INSERT INTO users (lastName, firstName, email, password, 
				  phone, fax, address1, address2, 
				  city, state, zip, ssn, company, 
				  empid, nameoncert, registerDate) 
				  VALUES
				  ('$lname', '$fname', '$email', '$password', '$phone', 
				  '$fax', '$address1', '$address2', '$city', '$state', 
				  '$zip', '$ssn', '$company', '$empid', '$nameoncert',
				  '$date');";
		$result = mysql_query($query);
}

 

Could it be that some of my variables have empty string values?

[thefortrees]

nevermind - one field was missing in my table.

[per1os]

Add this

 

$result = mysql_query($query) OR DIE(mysql_error() . "<br />" . $query);

 

It will tell you what and where the error is being thrown. If I had to say it is because of the password in the column list.

 

		$query = "INSERT INTO users (lastName, firstName, email, `password`, 
				  phone, fax, address1, address2, 
				  city, state, zip, ssn, company, 
				  empid, nameoncert, registerDate) 
				  VALUES
				  ('$lname', '$fname', '$email', '$password', '$phone', 
				  '$fax', '$address1', '$address2', '$city', '$state', 
				  '$zip', '$ssn', '$company', '$empid', '$nameoncert',
				  '$date');";

 

Feel free to try that but I highly suggest implementing that debugging section too.