Help with PHP/SQL Query

[Monk3h]

I am a bit rust at SQL and have tried to make a simple insert query but failed.

 

 

Please take a look and tell me where I went wrong.

 

$sql = ("INSERT INTO carbontrust
	(contact,
	company,
	address,
	postcode,
	telephone,
	mobile,
	email,
	employees,
	turnover,
	assetvalue,
	sme,
	tradetime,
	nature,
	typeofo,
	companyregisteredname,
	regnumber,
	vatreg,
	regaddress,
	catapply,
	fuelused,
	otherfuel,
	heatingpercent,
	factoryspaceheating,
	officeheating,
	hotwater,
	heaterrating,
	existingheaters,
	setbackheating,
	billavailable,
	factorysize,
	roofheighte,
	roofheightr,
	builddate,
	spraybooths,
	dustextract,
	air,
	rollershutters,
	weekoc,
	occupancy,
	woodwaste,
	woodavailable,
	upload)

VALUES ('$contact',
	'$company',
	'$address',
	'$postcode',
	'$telephone',
	'$mobile',
	'$email',
	'$employees',
	'$turnover',
	'$assetvalue',
	'$sme',
	'$tradetime',
	'$nature',
	'$typeofo',
	'$companyregisteredname',
	'$regnumber',
	'$vatreg',
	'$regaddress',
	'$catapply',
	'$fuelused',
	'$otherfuel',
	'$heatingpercent',
	'$factoryspaceheating',
	'$officeheating',
	'$hotwater',
	'$heaterrating',
	'$existingheaters',
	'$setbackheating',
	'$billavailable',
	'$factorysize',
	'$roofheighte',
	'$roofheightr',
	'$builddate',
	'$spraybooths',
	'$dustextract',
	'$air',
	'$rollershutters',
	'$weekoc',
	'$occupancy',
	'$woodwaste',
	'$woodavailable',
	'$upload')");

	$sql = @mysql_query($sql); 

 

 

The variables have been defined from a POST form. When the variables are printed out they apear correct.. However they are not inserted into the database.

 

Please help, been stuck for AGES.

 

 

Thanks in advance,

 

James.

[Maq]

Temporarily change this line to:

      $sql = mysql_query($sql) or die(mysql_error()); 

[Monk3h]

Unknown column 'vatreg' in 'field list'

[Maq]

Unknown column 'vatreg' in 'field list'

'vatreg' doesn't exist in your table.

[Pikachu2000]

That table has no column named vatreg, or it's misspelled, or miscapitalized in the query string.

[Monk3h]

Spelling mistake FTL!

 

 

Thanks mate! Been stuck on this for hours, didn't wanna get laughed out of a forum because I knew it would be a stupid mistake.

 

 

Thanks again!

[Maq]

Most mistakes are stupid and overly obvious, that's why they're so hard to recognize.

[Pikachu2000]

Don't worry, you won't get laughed out of here for that. No, we'll find some other reason . . .