Re: Oracle and PHP question

On Thu, 16 Mar 2006 21:16:53 +0100, Steff wrote:
> I have a question mark here because I don't know how to do it

That sounds like a good reason to ask a question. You can do it using the same trick I shown you before:

$query="insert into veg_type (id_type) values (:BIGMAC)";  

$stmt=oci_parse($c1,$query);

$ora_bind_by_name($stmt,":BIGMAC",$vegetable);  

oci_execute($stmt);

The other way would be by inserting constants:

$query="insert into veg_type (id_type) values ('castorbean')"

And then you can proceed as you originally did.

-- 
http://www.mgogala.com