Update query question
| From: | Jeff Self | Date: | Thu, 29 May 2003 19:12:07 +0000 |
| Subject: | Update query question | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-5683@lists.php.net to get a copy of this message | ||
I've got PEAR working correctly on my system. I'm trying to run an
update query. Here's what I've got:
// get variables from editjoblisting.php
$id = $_REQUEST['joblisting_id'];
$req_no = $_REQUEST['requisition_no'];
$jobdescription_id = $_REQUEST['jobdescription_id'];
$description = $_REQUEST['description'];
$vacancies = $_REQUEST['vacancies'];
$internal_only = $_REQUEST['internal_only'];
$active = $_REQUEST['active'];
$submitted_by = $_REQUEST['submitted_by'];
$table_fields = array('requisition_no', 'vacancies');
$table_values = array($req_no,$vacancies);
$table_name = 'joblisting';
$sth = $db->autoPrepare($table_name, $table_fields, DB_AUTOQUERY_UPDATE,
'joblisting_id = '.$id);
$result = $db->execute($sth, $table_values);
// Check the result object in case there was an error, and handle it
here.
if (DB::isError($result))
{
die($result->getMessage() . " " . $result->getDebugInfo());
}
?>
Here's the error message:
DB Error: no such field UPDATE joblisting SET requisition_no =
'03-349',vacancies = '1' WHERE joblisting_id = 1
Now if I change my statement handler to this:
$sth = $db->autoPrepare($table_name, $table_fields, DB_AUTOQUERY_UPDATE,
'joblisting_id = 1');
It works correctly. So how can I make the statement handler use my
variable $id since its gathering this from the form?
--
Jeff Self
Information Technology Analyst
City of Newport News
Personnel Department
2400 Washington Drive
Newport News, VA 23607
757-926-3741