Hello everyone, I wanted to have more precisions when to the utilization URL. I am going to try to explain a little bit what I make in order that you better to help me. Here is, my page1, I display a totality of data from an oracle basis I proceed for that as follows:
$Connection = ocilogon("user","pw","oracle8i"); //Requête $Query ="SELECT num_dembill,code_recepteur,date_emission,to_char(heure_emission,'hh24:mi:ss' ),date_reception, to_char(heure_reception,'hh24:mi:ss'),etat_dem FROM lrdembill WHERE code_recepteur='ATS' and etat_dem='NL'"; //analyse la requête $Statement = ociparse($Connection, $Query); //execution de la requête ociexecute($Statement); //affichage du tableau print"<TABLE BORDER=\"1\">"; print"<TR>"; print"<TH bgcolor=\"#CCCCCC\"><FONT color=\"#3300CC\">N°</FONT></TH>"; print"<TH bgcolor=\"#CCCCCC\"><FONT color=\"#3300CC\">Code recep</FONT></TH>"; print"<TH bgcolor=\"#CCCCCC\"><FONT color=\"#3300CC\">Date Emission</FONT></TH>"; print"<TH bgcolor=\"#CCCCCC\"><FONT color=\"#3300CC\">Heure Emission</FONT></TH>"; print"<TH bgcolor=\"#CCCCCC\"><FONT color=\"#3300CC\">Date Reception</FONT></TH>"; print"<TH bgcolor=\"#CCCCCC\"><FONT color=\"#3300CC\">Heure Reception</FONT></TH>"; print"<TH bgcolor=\"#CCCCCC\"><FONT color=\"#3300CC\">Etat Mess</FONT></TH>"; print"</TR>"; //remplissage du tableau while(ocifetch($Statement)) { print("<TR>\n"); //nombre de colonne $i = ocinumcols($Statement); print("<TD>"); //Imprimer le num_dembill sous forme de lien et utiliser URL pour le récupérer après if ($i=1) { $num=ociresult($Statement, 1); echo '<a href="forme7.php?num_dembill='.$num.'">'.$num.'</a>'; //echo '<a href="exemple.php?num_dembill='.$var['num_dembill'].'">.'</a>'; //print (ociresult($Statement, 1)); //print ("</a>"); } print("</TD>\n"); for($i=2; $i <= ocinumcols($Statement); $i++) { //imprimer la ligne comme "<TD>SMITH</TD>" print("<TD>"); if(ocicolumnisnull($Statement, $i)) { print(" "); } else { print (ociresult($Statement, $i)); } print("</TD>\n"); } print("</TR>\n"); } //liberer les ressources ocifreestatement($Statement); //arrêter la connection ocilogoff($Connection); and therefore I have in display of a table or the num_dembill displays in bond, I wanted to recuperate this same number to display the detail in the page2 of the recording that wears this same number but the problem is that it does not transmit this same number to the page2 and I do not arrive truly to divulge the problem it gives in the page2 the detail of the last record of the selection, I proceed as follows: $conn = ociLogon("user","pw","oracle8i"); $sql="select num_dembill,a.code_structure,a.code_emetteur, a.code_recepteur,a.date_emission, to_char(a.heure_emission,'hh24:mi:ss') heure_e, a.date_reception,to_char(a.heure_reception,'hh24:mi:ss') heure_r, b.nom_utilisateur,a.matric_agent,a.tel_bur_agent,a.VISA_DIRECT_STRU, a.NOM_DIRECT_STRUC,a.VISA_RESP_RESER,a.NOM_RESP_RESER, a.VISA_RESP_ACHA,a.NOM_RESP_ACHA,a.VISA_RESP_TRANS,a.NOM_RESP_TRANS, a.VISA_RESP_REP,a.NOM_RESP_REP,a.DATE_OPTION,a.CHEMINEMENT, a.etat_dem,c.nom_agnt,c.prenom_agnt,c.intitu_fonc,c.echeln,c.echell, c.libell_stru from lrdembill a, lrutilmess b,lragents c where a.code_recepteur='ATS'and (a.code_emetteur=b.code_utilisateur) and (a.matric_agent=c.matric_agnt)"; $sqlutil="select nom_utilisateur from lrutilmess where code_utilisateur='ATS'"; $stmt = ociparse($conn,$sql); $stmtutil= ociparse($conn,$sqlutil); ociDefineByName($stmt,"NUM_DEMBILL",&$num_dem); ociDefineByName($stmt,"CODE_RECEPTEUR",&$code_recepteur); ociDefineByName($stmt,"CODE_EMETTEUR",&$code_emetteur); ociDefineByName($stmt,"NOM_UTILISATEUR",&$emetteur); ociDefineByName($stmt,"DATE_EMISSION",&$date_emission); ociDefineByName($stmt,"HEURE_E",&$heure_emission); ociDefineByName($stmt,"DATE_RECEPTION",&$date_reception); ociDefineByName($stmt,"HEURE_R",&$heure_reception); ociDefineByName($stmt,"MATRIC_AGENT",&$matric_agnt); ociDefineByName($stmt,"NOM_AGNT",&$nom_agnt); ociDefineByName($stmt,"PRENOM_AGNT",&$prenom_agnt); ociDefineByName($stmt,"INTITU_FONC",&$fonct_agnt); ociDefineByName($stmt,"ECHELN",&$echeln_agnt); ociDefineByName($stmt,"ECHELL",&$echel_agnt); ociDefineByName($stmt,"LIBELL_STRU",&$struc_agnt); ociDefineByName($stmt,"TEL_BUR_AGENT",&$tel_agnt); ociDefineByName($stmt,"CODE_STRUCTURE",&$code_structure); ociDefineByName($stmt,"VISA_DIRECT_STRU",&$visa_direct_stru); ociDefineByName($stmt,"NOM_DIRECT_STRUC",&$nom_direct_struc); ociDefineByName($stmt,"VISA_RESP_RESER",&$visa_resp_reser); ociDefineByName($stmt,"NOM_RESP_RESER",&$nom_resp_reser); ociDefineByName($stmt,"VISA_RESP_ACHA",&$visa_resp_acha); ociDefineByName($stmt,"NOM_RESP_ACHA",&$nom_resp_acha); ociDefineByName($stmt,"VISA_RESP_TRANS",&$visa_resp_trans); ociDefineByName($stmt,"NOM_RESP_TRANS",&$nom_resp_trans); ociDefineByName($stmt,"VISA_RESP_REP",&$visa_resp_rep); ociDefineByName($stmt,"NOM_RESP_REP",&$nom_resp_rep); ociDefineByName($stmt,"CHEMINEMENT",&$cheminement); ociDefineByName($stmt,"ETAT_DEM",&$etat_dem); ociDefineByName($stmtutil,"NOM_UTILISATEUR",&$recepteur); ociexecute($stmt); ociexecute($stmtutil); while (ociFetch($stmt)) { } while (ociFetch($stmtutil)) { } print("<a name=Debut><h3></h3></a>"); print("<h1 align=center><FONT color=\"#FF0000\"><B>Demande d'Achat de Billet pour Mission à l'Etranger</FONT></B></h1>"); //print("<FONT color=\"#3300CC\" align=center><B>Demande d'Achat de Billet pour Mission à l'Etranger</FONT></B>"); print("<BR>"); print ("<A href=billet_lien.php>Revenir à la page précédente</A>"); print("<BR>"); print("<BR>"); print("<table>"); print("<TR>"); print("<TH align=right><FONT color=\"#3300CC\"><B>"."N°:</FONT></B></TH>"); print("<TH><INPUT TYPE=\"text\" NAME=\"num\" SIZE=\"15\" VALUE=\"$num_dem\" readonly > </TH>"); print("</TR>"); print("<TR>"); print("<TD align=right><FONT color=\"#3300CC\"><B>"."Code Emetteur :</FONT></B></TD>"); print("<TH><INPUT TYPE=\"text\" NAME=\"code_emet\" SIZE=\"15\" VALUE=\"$code_emetteur\" readonly></TH>"); print("<TD align=right><FONT color=\"#3300CC\"><B>"."Nom Emetteur :</FONT></B></TD>"); print("<TH><INPUT TYPE=\"text\" NAME=\"emet\" SIZE=\"15\" VALUE=\"$emetteur\" readonly></TH> "); print("</TR>"); print("<TR>"); ect..... I believed that what it had to make in the page2 it is to make the SELECT by report to the num_dembill of the page1.(SELECT.......WHERE num_dembillpage2=num). Please if you can help me I you would be truly grateful, it is truly urgent thank you:-) LYNDA HAOUHACH Ingénieur Systèmes SONATRACH LTH Émail: [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]