Query oci_parse() Apache error

Query oci_parse() Apache error

am 19.04.2006 00:56:53 von Stephen V

I get this error, apparently because of my Query:



Apache.exe has encountered a problem and needs to close. We are sorry for
the inconvenience.





the error in on oci_parse() , but when I replace the above query with for
example "select * from clients"; I don't get the error. Though I need to
use query I put in variable $query....

All my other variables are ok, and the query works when I use it in SQL
worksheet for instance. (I use oracle 9i, php5, apche 1.3)



what can I do with that query to make it work?





$req_id = $_GET['request_id'];

print "request id : $req_id
";

$req_name = $_POST['request_name'];

print "request_name -> $req_name
";

$req_date = $_POST['request_date'];

print "request_date -> $req_date
";

$req_client_id = $_POST['request_client_name'];

print "request_client_name -> $req_client_id
";

$req_req_type_id = $_POST['request_type'];

print "request_type -> $req_req_type_id
";

$req_brand_id = $_POST['request_brand_name'];

if ($req_brand_id=='Brand Name') $req_brand_id='NULL';



print "request_brand_name -> $req_brand_id
";

$req_exp_date = $_POST['request_expected_date'];

print "request_expected_date -> $req_exp_date
";

$req_comment = $_POST['request_comment'];

print "request_comment -> $req_comment
";



$c1=oci_connect("john","lago");





$query="update requests set

request_name='$req_name'

,request_date= to_date('$req_date','DD.MM.YYYY')

,request_client_id=2

,request_request_type_id = $req_client_id

,request_brand_id = $req_brand_id

,request_wished_delivery_date =
to_date('$req_exp_date','DD.MM.YYYY')

,request_comment ='$req_comment'

where request_id =$req_id";





$stmt=oci_parse($c1,"select * from clients");