"Unknown column test3 in field list" error in MySQL

[MythicFrost]

Hi,

I'm trying to do this:

$sqlAdd[$i] = "INSERT INTO ct_".$country." (name, url) VALUES (test3, test)";
if (!mysql_query(mysql_real_escape_string($sqlAdd[$i]), $con)) {
    die('Error: ' . mysql_error());
}

(adding into the table ct_int in the field name and url rows, the values test3 and test)

The error I get is:

Error: Unknown column 'test3' in 'field list'

How come its looking for column "test" it should be looking for the column "name"? What's up with that ey?

Kind Regards

 

[angelwatt]

Values should be strings, which need to be quoted.

$sqlAdd[$i] = "INSERT INTO ct_".$country." (name, url) VALUES ('test3', 'test')";

which will put "test3" into column name, and "test" into column url.