Please correct me with this code

[qwest]

hi guyz

I have installed PHP-Apache-Oracle 8i as the combination for my small website. OS is Windows 2000 Advanced Server.

I have successfully connected to Oracle from PHP through Apache....but the problem is i am not able to see the results of my query.

Can somebody tell me what is the mistake that i have done here.

Thx in advance

<?php
$connection = OCILogon("scott","tiger","test");
$stmt = OCIParse($connection, "select user_name,mit_user_no from user_table");
OCIExecute($stmt);
print "<TABLE CELLSPACING=\"0\" CELLPADDING=\"3\" BORDER=\"1\">\n";
print "<TR>";
print "<TH>USERNAME</TH>";
print "<TH>MIT_USER_NO</TH>";
print "</TR>\n";
while(OCIFetch($stmt))
{
print " <TR>\n";
print " <TD>" . OCIResult($stmt, "user_name") . "</TD>\n";
print " <TD>" . OCIResult($stmt, "mit_user_no") . "</TD>\n";
print " </TR>\n";
}
print "\n";
OCIFreeStatement($stmt);
OCILogoff($connection);
?>

i am getting just blank table with the captions username and mit_user_no....but the surprising thing is that if i check the source code from IE...30 blank <TD></TD> is created which is the exact record count of this table which i am querying.

Regardz
Qwest

[majik-sheff]

Try this out:

print " <TD>" . OCIResult($stmt, "USER_NAME") . "</TD>\n";
print " <TD>" . OCIResult($stmt, "MIT_USER_NO") . "</TD>\n";

[qwest]

thx a lot pal....it worked like magic....but when i am getting the result properly...this block of code should not get executed right....but it is getting executed....and with addition to result i am getting error message saying

Warning: OCIFetch: ORA-01002: fetch out of sequence in c:\apache\apache\htdocs\scripts\oracon.php on line 25
1002 ORA-01002: fetch out of sequence

if(! OCIFetch($stmt))
{
$err = OCIError($stmt);
echo $err[ "code" ]." ".$err[ "message" ]."\n";
die();
}

whatz goin wrong pal???

Thx for ur help

Regardz
Qwest

[Duey]

why not use mysql 😉

[qwest]

ok guyz thx for all ur help...got it dead right...there was a slight problem...i had misplaced the code...how stupid of me....but still this was my first piece of coding in PHP 😉

Regardz
Qwest