Codezwiz >> Forums >> General PHP Nuke Help >> sql insert problem with columns named one,two,three

This is a strange question.

I have an insert and the columns are name one, two, and three.

It will not go, but if I just use "the one column" it works. Is there any reason for this?

$rid = intval($rid);
$rtitle = strip_tags($rtitle);
$one = strip_tags($one);
$two = strip_tags($two);
$three = strip_tags($three);
$sql = "INSERT INTO ".$prefix."_server_rules (`rid`,`rpos`,`rtitle`,`rdetails`,`one`,'two','three') VALUES ('NULL','NULL','$rtitle','$rdetails','$one','$two','$three')";
$db->sql_query($sql) or die ('Could not insert into table');

I figured this out.

In the above case my one two and three fields where inside the loop. Therefor it was only returning one of those values.