Hi ,
I have a problem retrieving and displaying data from an oracle8i database.
I write the data using a PHP file and the same include connection file, the data exists (checked with SQL*Plus) but nothing appears...
can someone help????
Thanks!!!!
<table width="100%" cellspacing="2" cellpadding="2" border="0">
<?php
//Include the database connexion and selection file
include("conn.inc");
//Write the statement
$stmt = ociparse($conn,"Select Usr_f_name, Usr_l_name, Usr_num from USR");
ociexecute($stmt,OCI_DEFAULT);
//Print in the HTML table the list of users
while (ocifetch($stmt,OCI_DEFAULT)){
printf("<tr><td width=\"25\"></td><td><font face=\"Arial,Helvetica,sans-serif\" size=\"-1\">
<a href=\"javascript:MM_openBrWindow('utilisateur_fiche_modif.php3?usernum=".ociresult($stmt,"Usr_num").",'utilisateur_fiche','width=430,height=500')\">
".ociresult($stmt,"Usr_f_name")." ".ociresult($stmt,"Usr_l_name")." </a><p><p></font></td></tr>");
}
OCIFreeStatement($stmt);
OCILogoff($conn);
?>
<tr>
