Query oci_parse() Apache error

From: John Lagoli <stephane.vollet_at_bluewin.ch>
Date: Wed, 19 Apr 2006 00:56:53 +0200
Message-ID: <44456eb6_7@news.bluewin.ch>

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 <br>";

$req_name = $_POST['request_name'];

print "request_name -> $req_name <br>";

$req_date = $_POST['request_date'];

print "request_date -> $req_date <br>";

$req_client_id = $_POST['request_client_name'];

print "request_client_name -> $req_client_id <br>";

$req_req_type_id = $_POST['request_type'];

print "request_type -> $req_req_type_id <br>";

$req_brand_id = $_POST['request_brand_name'];

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

print "request_brand_name -> $req_brand_id <br>";

$req_exp_date = $_POST['request_expected_date'];

print "request_expected_date -> $req_exp_date <br>";

$req_comment = $_POST['request_comment'];

print "request_comment -> $req_comment <br>";

$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");

Received on Tue Apr 18 2006 - 17:56:53 CDT