What are the rules on data being entered?

28 views Asked by At

I'm trying to enter 'validation - the confirmation of an email' and it fails because VALIDATION is a keyword in MySQL. do I need to escape the first letter? In this case the v in validation? Do word/key replacement after checking for the destination key? or is there a simpler method?

I currently have:

$db->issue("INSERT INTO tasks (task,added) VALUES('".htmlentities($task,ENT_QUOTES|ENT_HTML401)."',curdate())");
0

There are 0 answers