insert error

[esoteric]

Can anyone see something wrong with this? It's driving me crazy and throwing up an error

 

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''user_name', 'user_email', 'user_credit', 'fname', 'lname', 'hous' at line 3

 

$sql_insert = ("INSERT INTO users
  			(
		'user_name',
		'user_email',
		'user_credit',
		'fname',
		'lname',
		'house_num',
		'addr',
		'addr2',
		'county',
		'postcode',
		'pwd',
		'dobDay',
		'dobMonth',
		'dobYear',
		'tel',
		'date',
		'users_ip',
		'avatar'
		)
	    VALUES
	    (
		'".$user_name."',
		'".$usr_email."',
		'0.00',
		'".$fname."',
		'".$lname."',
		'".$house_num."',
		'".$addr."',
		'".$addr2."',
		'".$county."',
		'".$postcode."',
		'".$sha1pass."',
		'".$dobDay."',
		'".$dobMonth."',
		'".$dobYear."',
		'".$tel."',
		'".$date."',
		'".$user_ip."',
		'/images/default/avatar.png'
		)");
		echo $sql_insert;
mysql_query($sql_insert,$link) or die(mysql_error());

 

I can't see what i wrong with it, i removed all the blank entries (ones with the value 'null',) but it didn't make any difference

[PFMaBiSmAd]

The error is in your list of column names, they have quotes around each of them, making them string data values instead of column names.

[litebearer]

As per PFM...

$sql_insert = "INSERT INTO users (user_name, user_email, user_credit, fname, lname, house_num, addr, addr2, county, postcode, pwd, dobDay, dobMonth, dobYear, tel, date, users_ip, avatar)  VALUES('$user_name', '$usr_email', '0', '$fname', '$lname', '$house_num', '$addr', '$addr2', '$county', '$postcode', '$sha1pass', '$dobDay', '$dobMonth', '$dobYear', '$tel', '$date', '$user_ip', '/images/default/avatar.png'";

echo $sql_insert;