Oracle PHP error

[Anon]

hi
i got this error when using PHP with Oracle

Warning: OCIParse: Error while trying to retrieve text for error ORA-01741

Part of my code:
$query1 = \"SELECT * FROM product WHERE product_ID = \\"$product_ID\\"\";

$cursor1 = OCIParse($connection,$query1)or die (\"Couldn\'t parse statement.\");
OCIExecute ($cursor1)or die (\"Couldn\'t execute statement.\");

while (OCIFetchInto($cursor1, $values)) {
$product_ID = $values[0];
$product_name = $values[1];
$product_price = $values[2];
$product_description = $values[3];
$product_category = $values[4];
$product_stock = $values[5];
}
?>

what is wrong?

[nigel_belanger]

Try replacing:

$query1 = \"SELECT * FROM product WHERE product_ID = \\"$product_ID\\"\";

with:

$query1 = "SELECT * FROM product WHERE product_ID = '$product_ID'";

To my knowledge, backslashes are only needed before quotes when using an "echo" statement.

[Anon]

thanks for pointing my mistake wif escape characters...always have trouble with that....

but i still cant display my product information on each product

something wrong wif the OCIFetchInto command? sorry i'm a beginner in PHP 🙂

[Anon]

thanks
i solved my problem
problems lies on my array numbering