Description: ------------ Can not use the word "select" as input of text field when trying to build web application. It will return the following error: "DB Error: unknown error". I try to insert data using prepare and execute, and error out. My system information are as follow: Ubuntu 10.04.3 LTS PHP Version 5.3.2-1ubuntu4.18 Pear DB-1.7.13 Informix 11.5 Test script: --------------- $sql='update office set office_name=?,office_type=?,office_phone=? where office_number=?'; $sth = $dbh->prepare($sql); if(DB::isError($sth)) { die ($sth->getDebugInfo()); } $data = array($_GET['office_name'],$_GET['office_type'],$_GET['office_phone'],$_GET['office_number']); $rcode1 = $dbh->execute($sth,$data); Expected result: ---------------- Expected to update office_name, office_type, and office_phone. Actual result: -------------- When the office_name is equal to "Select dental" it failed. It failed because it include the keyword "select". I get the following error " DB Error: unknown error" from Informix. When I tried to update the table directly using isql, it will work.