Plz Help Me

[Anon]

I'm trying to configure a windows 2000 server running iis to connect to an oracle database using php.

I've installed PHP and it seems to be working fine. However when i run the script below i get jargen for an answer. The script is supposed to run a first name but instead i get weird characters like H~^* as the result.

<?php
$db="mmst"; \instince name
$conn = OCILogon("username","password",$db);
$sql="Select firstname from trapeze.clients where clientid = 10 ";
$result = OCIParse($conn,$sql);
$OK = OCIExecute($result, $CONN);
printf (OCIResult($result,"FIRSTNAME"));
OCIFreeStatement($result);
OCILogoff($conexion);
?>
</body>

I've done net 8 config and all that good stuff.. but i don't get why its giving me jumble as a result... PLZ help if you can

[herve]

It's been a long time since I use Oracle,
but may be you should use lowercase
in OCIResult ($result,"firstname") ?

[Anon]

Thats how i oringaly had it and it but when i had it like that i got no results...when i changed it to upper case...i got un-readable stuff... I'm wondering if it has to do with the character set i used when i first created the database...