our server has recently been moved from php 3 to php 5. the code differences are enough, but on top of that, i'm going to an Oracle db instead of mysql. i'm learing it fairly quickly, but for some crazy reason, the code below won't work and gives this error:
Warning: ociexecute() [function.ociexecute]: OCIStmtExecute: ORA-00904: invalid column name in C:\Inetpub\wwwroot\faciltst\HOMSstatchng.php on line 72
why is it blowing up on the ociexecute statement when it works just fine for a select statement about 10 lines up?
here is the code - i just want to insert into a field (simple enough)
Code: Select all
<?php
71 $updateqry1 = OCIParse($Link, "UPDATE ASSIGNMENTS SET TERM = '$term' WHERE ASSIGNMENTS_STUDENTS_ID = '$sid'");
72 OCIExecute($updateqry1);
73 OCILogoff($Link);
?>thankx
Shane