Annoying sql problem ..

[dbeezzz]

I seem to be getting a really annoying sql problem on a very simple query

$sql = "INSERT INTO constellation ( constellation_coverletter )
					VALUES ( $val_1  )
						";

where $val_1 = 'coverletter'
It gives me

SQL Error : 1054 Unknown column 'coverletter' in 'field list'

INSERT INTO constellation ( constellation_coverletter ) VALUES ( coverletter )

Line : 43
File : my_presentation.php

... why does it tell me that the $val_1 is an 'unknown column' ? It's a value and not a col in the first place.

 

[dbeezzz]

Ok I got it thanks ... I was leaving out the ' ' ... d'oh !

 

[itech20059]

You should use $POST if you are doing and insert via a form using php.

$sql = "INSERT INTO constellation ( 'constellation_coverletter ')VALUES ( ' " .$_POST['val_1']." ' )";

 

[lgarner]

There's no reason to think it's a $_POST or $_GET variable, but if it is you'd probably want to use mysql_real_escape_string($val_1) instead.