Hello,
i am using the following query inorder to update my fields in my table.when i ever i run my scripts, it gives me an error always that there is an error in the update statement.
I tried to change it in many ways, but itz still driving me nuts,huh!could somebody please tell me where the error is?
Many thanks
$update_sql = "update TBL_RBS SET ".
"RBS_TFTPSERVERIPADDRESS = \'{$HTTP_POST_VARS['tftp_server'][$cntr]}\', ".
"RBS_TFTPFILENAME = \'{$HTTP_POST_VARS['tftp_file'][$cntr]}\', ".
"RBS_ENROLMENT = '$enrolment', ".
"RBS_CIPHERING = '$ciphering', ".
"RBS_RFPI = \'{$HTTP_POST_VARS['rfpi'][$cntr]}\', ".
"RBS_IPADDRESS = \'{$HTTP_POST_VARS['ip_address'][$cntr]}\', ".
"RBS_MACADDRESS = \'{$HTTP_POST_VARS['mac_address'][$cntr]}\', ".
"RBS_SUBNETMASK = \'{$HTTP_POST_VARS['subnet_mask'][$cntr]}\', ".
"RBS_ROUTERIP = \'{$HTTP_POST_VARS['router_ip'][$cntr]}\' ".
" where RBS_TFTPSERVERIPADDRESS = \'{$HTTP_POST_VARS['old_tftp_server'][$cntr]}\' and ".
"RBS_TFTPFILENAME = \'{$HTTP_POST_VARS['old_tftp_file'][$cntr]}\' and ".
"RBS_ENROLMENT = \'{$HTTP_POST_VARS['old_enrolment'][$cntr]}\' and ".
"RBS_CIPHERING = \'{$HTTP_POST_VARS['old_ciphering'][$cntr]}\' and ".
"RBS_RFPI = \'{$HTTP_POST_VARS['old_rfpi'][$cntr]}\' and ".
"RBS_IPADDRESS = \'{$HTTP_POST_VARS['old_ip_address'][$cntr]}\' and ".
"RBS_MACADDRESS = \'{$HTTP_POST_VARS['old_mac_address'][$cntr]}\' and ".
"RBS_SUBNETMASK = \'{$HTTP_POST_VARS['old_subnet_mask'][$cntr]}\' and ".
"RBS_ROUTERIP = \'{$HTTP_POST_VARS['old_router_ip'][$cntr]}\'";
$result = ibase_query($connection, $update_sql);
if (!$result) {
/ if query is failed/
echo "There was an error executing the update statement.<br />".
"SQL=$update_sql<br />\n";
