oupsss!!!
g oublié de mettre mon code que voici!!!!
[php]<?php session_start();
//echo "<font face=arial size=3 color=red >==>name_ident $n_i **</font><br>";
$c_melle = "Miss.";
$c_mme = "Mrs.";
$c_m = "Mr.";
$civilite = " ";
//$name_ident_var = $HTTP_SESSION_VARS["n_i"];
//echo "<font face=arial size=3 color=red >==>name_ident $HTTP_SESSION_VARS[n_i]; **</font><br>";
$query = "select * from employee where name_ident='$n_i' ";
//echo "<font face=arial size=3 color=red >==>query $query **</font><br>";
$link=mysql_connect() or die ("Connecting error");
$sd_bdd="sellmore";
mysql_select_db($sd_bdd) or die ("Connecting bdd error");
$result_2=mysql_query($query);
//echo "<font face=arial size=5 color=red >==>result $result **</font><br>";
$row_2=mysql_fetch_row($result_2);
//echo "<font face=arial size=3 color=red >==>name_ident $row_2[0] **</font><br>";
//echo "<font face=arial size=3 color=red >==>name $row_2[1] **</font><br>";
//echo "<font face=arial size=3 color=red >==>vor_name $row_2[2] **</font><br>";
//echo "<font face=arial size=3 color=red >==>civilite_name $row_2[3] **</font><br>";
//echo "<font face=arial size=3 color=red >==>role $row_2[4] **</font><br>";
//echo "<font face=arial size=3 color=red >==>territory_group $row_2[5] **</font><br>";
//echo "<font face=arial size=3 color=red >==>y_obj $row_2[6] **</font><br>";
//echo "<font face=arial size=3 color=red >==>q1_obj $row_2[7] **</font><br>";
//echo "<font face=arial size=3 color=red >==>q2_obj $row_2[8] **</font><br>";
//echo "<font face=arial size=3 color=red >==>q3_obj $row_2[9] **</font><br>";
//echo "<font face=arial size=3 color=red >==>q4_obj $row_2[10] **</font><br>";
//echo "<font face=arial size=3 color=red >==>m1_obj $row_2[11] **</font><br>";
//echo "<font face=arial size=3 color=red >==>m2_obj $row_2[12] **</font><br>";
//echo "<font face=arial size=3 color=red >==>obj $row_2[13] **</font><br>";
//echo "<font face=arial size=3 color=red >==>ytd $row_2[14] **</font><br>";
//echo "<font face=arial size=3 color=red >==>ytd_percent $row_2[15] **</font><br>";
//echo "<font face=arial size=3 color=red >==>avance_retard $row_2[16] **</font><br>";
//echo "<font face=arial size=3 color=red >==>a_value $row_2[17] **</font><br>";
//echo "<font face=arial size=3 color=red >==>b_value $row_2[18] **</font><br>";
//echo "<font face=arial size=3 color=red >==>c_value $row_2[19] **</font><br>";
//echo "<font face=arial size=3 color=red >==>d_value $row_2[20] **</font><br>";
//echo "<font face=arial size=3 color=red >==>e_value $row_2[21] **</font><br>";
//echo "<font face=arial size=3 color=red >==>pipe_1 $row_2[22] **</font><br>";
//echo "<font face=arial size=3 color=red >==>pipe_2 $row_2[23] **</font><br>";
//echo "<font face=arial size=3 color=red >==>val_opportunity $row_2[24] **</font><br>";
//echo "<font face=arial size=3 color=red >==>nb_a $row_2[25] **</font><br>";
//echo "<font face=arial size=3 color=red >==>nb_b $row_2[26] **</font><br>";
//echo "<font face=arial size=3 color=red >==>nb_c $row_2[27] **</font><br>";
//echo "<font face=arial size=3 color=red >==>nb_d $row_2[28] **</font><br>";
//echo "<font face=arial size=3 color=red >==>nb_e $row_2[29] **</font><br>";
//echo "<font face=arial size=3 color=red >==>average $row_2[30] **</font><br>";
mysql_close($link);
?>
<html>
<head>
<title>Sell More</title>
<meta http-equiv=Content-Type content=text/html; charset=iso-8859-1>
<link rel=StyleSheet href=./css/page_css.css type=text/css media=screen>
</head>
<body>
<a name=top></a>
<center>
<table border=0 cellpadding=0 cellspacing=0 ><tr>
<td bgcolor=#CC0000 border=0 width=600 height=2> </td>
</tr></table>
<table width=600 border=0 cellpadding=0 cellspacing=0>
<tr>
<td bgcolor=#CC0000 border=0 width=11 height=25><span class=text9></font></span></td>
<td bgcolor=#CC0000 border=0 width=441><span class=texttitresite><strong>SELLMORE</strong></font></span></td>
<td bgcolor=#CC0000 border=0 width=148><div align=left><span class=text9>
<?php echo (date(' d/m/Y H:i ')); ?></span></div></td>
</tr>
</table>
<table border=0 cellpadding=0 cellspacing=0 ><tr>
<td bgcolor=#CC0000 border=0 width=432 height=20> </td>
<td bgcolor=#CC0000 border=0 width=168 height=20> </td>
</tr></table>
<table border=0 cellpadding=0 cellspacing=0 width=600 bgcolor=#ffffff>
<tr>
<td width=11 ><span class=text8></span></td>
<td width=410 ><div align=left><a href=./connect_php-ret.php><span class=textwel><u>SellMore</u></span></a><span class=textwel>>Create Customer</span></div></td>
<td width=179 ><div align=left><span class=textwel>
<?php
if ( $row_2[3] == "a" ) { $civilite = $c_melle; }
if ( $row_2[3] == "b" ) { $civilite = $c_mme; }
if ( $row_2[3] == "c" ) { $civilite = $c_m; }
echo "Welcome $civilite $row_2[1] $row_2[2] ";
?>
</span></div></td>
</tr>
</table>
<table border=0 cellpadding=0 cellspacing=0 ><tr><td height=10></td></tr></table>
<table border=1 bordercolor=#CC0000 cellpadding=0 cellspacing=0 width=600 height=50>
<tr>
<td width=150 > <table width=100% height=100% bgcolor=#CC0000 border=1 bordercolor=#CC0000 align=center cellpadding=0 cellspacing=0>
<tr>
<td width=410 height=20 ></td>
</tr>
</table></td>
<td width=444 ><div align=center>
<table border=0 bordercolor=#CC0000 width=100% cellpadding=0 cellspacing=0>
<tr>
<td width=33% align=left bgcolor=#CC0000><span class=texttitre> CREATE</span></td>
<td width=34% align=left bgcolor=#CC0000><span class=texttitre> UPDATE</span></td>
<td width=33% align=left bgcolor=#CC0000><span class=texttitre> SHOW
ME</span></td>
</tr>
<tr>
<td width=33% valign=baseline bgcolor=#ffffff align=center ><table border=0 cellpadding=0 cellspacing=0 width=100%>
<tr>
<td width=10%></td>
<td valign=baseline width=90%><img src=./images/mini-fleche-r.gif width=6 height=9 ><!--a href=./commercial-create-customer.html--><span class=textwel> Customer</span><!--/a--></td>
</tr>
<tr>
<td width=10%></td>
<td valign=baseline width=90%><img src=./images/mini-fleche-r.gif width=6 height=9 ><a href=./commercial-create-opportunity.php><span class=text9r> Opportunity</span></a></td>
</tr>
<tr>
<td width=10%></td>
<td valign=baseline width=90%>
<span class=text9B> </span></td>
</tr>
</table></td>
<td width=34% valign=baseline align=center bgcolor=#ffffff> <table border=0 cellpadding=0 cellspacing=0 width=100%>
<tr>
<td width=10%></td>
<td valign=baseline width=90%><img src=./images/mini-fleche-r.gif width=6 height=9 ><a href=./commercial-upd-customer.php><span class=text9r> Customer</span></a></td>
</tr>
<tr>
<td width=10%></td>
<td valign=baseline width=90%><img src=./images/mini-fleche-r.gif width=6 height=9 ><a href=./commercial-upd-opportunity.php><span class=text9r> Opportunity</span></a></td>
</tr>
<tr>
<td width=10%></td>
<td valign=baseline width=90%><img src=./images/mini-fleche-r.gif width=6 height=9 ><a href=./commercial-upd-opportunity-status.php><span class=text9r> Opportunity
- status</span></a></td>
</tr>
</table></td>
<td width=33% valign=baseline align=center bgcolor=#ffffff><table border=0 cellpadding=0 cellspacing=0 width=100%>
<tr>
<td width=10%></td>
<td valign=baseline width=2%>
</td>
<td width=5%> </td>
<td align=left valign=baseline width=88%><span class=text9B> </span></td>
</tr>
</table></td>
</tr>
</table>
</div></td>
</tr>
</table>
<table border=0 bordercolor=#CC0000 cellpadding=0 cellspacing=0 bgcolor=#FFFFFF width=600 height=353>
<tr>
<td width=167 height=345 bgcolor=#FFFFFF border=0 >
<table border=0 cellpadding=0 cellspacing=0 height=30 width=100%>
<tr>
<td valign=baseline align=left width=0%><div align=center></div></td>
</tr>
</table>
<table width=83% height=20 border=0 align=center cellpadding=0 cellspacing=0 bordercolor=#CC0000 bgcolor=#cc0000>
<tr>
<td width=72% bgcolor=#FFFFFF><div align=right><span class=texttitre2>Promotions</span></div></td>
<td width=8% bgcolor=#FFFFFF><span class=texttitre> </span></td>
<td width=20%><span class=texttitre> +3</span></td>
</tr>
</table>
<table width=83% height=20 border=1 align=center cellpadding=0 cellspacing=0 bordercolor=#CC0000 bgcolor=#cc0000>
<tr>
<td width=83% bgcolor=#FFFFFF border=1 bordercolor=#CC0000 ><div align=center>
<table width=100% cellpadding=0 cellspacing=0>
<tr>
<td width=0% height=5></td>
<td valign=baseline align=left width=50%></td>
<td align=left valign=baseline width=50%></td>
</tr>
<tr>
<td width=0%></td>
<td valign=baseline align=left width=50%><span class=text9B> Objectif
</span></td>
<td align=left valign=baseline width=50%><span class=text9Bonus>
<?php echo "$row_2[6] K€"; ?></span></td>
</tr>
<tr>
<td width=0% height=5></td>
<td valign=baseline align=left width=50%></td>
<td align=left valign=baseline width=50%></td>
</tr>
<tr>
<td width=0%></td>
<td valign=baseline align=left width=50%><span class=text9b> YTD
</span></td>
<td align=left valign=baseline width=50% ><span class=text9Bonus>
<?php echo "$row_2[14] K€"; ?></span></td>
</tr>
<tr>
<td width=0%></td>
<td valign=baseline align=left width=50%><span class=text9b> YTD%
</span></td>
<td align=left valign=baseline width=50%><span class=text9Bonus>
<?php echo "$row_2[15] %"; ?></span></td>
</tr>
<tr>
<tr>
<td width=0% height=5></td>
<td valign=baseline align=left width=50%></td>
<td align=left valign=baseline width=50%></td>
</tr>
<tr>
<td width=1%></td>
<td valign=baseline align=left width=50%><span class=text9b> A
Values </span></td>
<td align=left valign=baseline width=49%><span class=text9Bonus>
<?php echo "$row_2[25] / $row_2[17] K€"; ?></span></td>
</tr>
<tr>
<td width=1%></td>
<td valign=baseline align=left width=50%><span class=text9b> B
Values </span></td>
<td align=left valign=baseline width=49% ><span class=text9Bonus>
<?php echo "$row_2[26] / $row_2[18] K€"; ?></span></td>
</tr>
<tr>
<td width=1%></td>
<td valign=baseline align=left width=50%><span class=text9b> C
Values </span></td>
<td align=left valign=baseline width=49%><span class=text9Bonus>
<?php echo "$row_2[27] / $row_2[19] K€"; ?></span></td>
</tr>
<tr>
<td width=0% height=5></td>
<td valign=baseline align=left width=50%></td>
<td align=left valign=baseline width=50%></td>
</tr>
<tr>
<td width=1%></td>
<td valign=baseline align=left width=50%><span class=text9b> D
Values </span></td>
<td align=left valign=baseline width=49%><span class=text9Bonus>
<?php echo "$row_2[28] / $row_2[20] K€"; ?></span></td>
</tr>
<tr>
<td width=1%></td>
<td valign=baseline align=left width=50%><span class=text9b> E
Values</span></td>
<td align=left valign=baseline width=49%><span class=text9Bonus>
<?php echo "$row_2[29] / $row_2[21] K€"; ?></span></td>
</tr>
<tr>
<td width=0% height=5></td>
<td valign=baseline align=left width=50%></td>
<td align=left valign=baseline width=50%></td>
</tr>
<tr>
<td width=1%></td>
<td valign=baseline align=left width=50%><span class=text9b> Pipe
values</span></td>
<td align=left valign=baseline width=49%><span class=text9Bonus>
<?php $nb_val_abcde=$row_2[25]+$row_2[26]+$row_2[27]+$row_2[28]+$row_2[29];
echo "$nb_val_abcde / $row_2[22] K€"; ?>
</span></td>
</tr>
<tr>
<td width=1%></td>
<td valign=baseline align=left width=50%><span class=text9b> Average</span></td>
<td align=left valign=baseline width=49%><span class=text9Bonus>
<?php echo "$row_2[30] K€"; ?></span></td>
</tr>
<tr>
<td width=0% height=5></td>
<td valign=baseline align=left width=50%></td>
<td align=left valign=baseline width=50%></td>
</tr>
</table>
</div></td>
</tr>
</table>
<table width=50 height=120 border=0 align=center cellpadding=0 cellspacing=0 bgcolor=#FFFFFF>
<tr>
<td width=24%></td>
</tr>
</table>
</td>
<td width=433 valign=top align=center>
<table width=10 height=30 border=0 cellpadding=0 cellspacing=0>
<tr>
<td width=600 align=center> <form name="dv" action=./commercial-create-customer_php.php method="post" ></td>
</tr>
</table>
<table width=50 height=200 border=0 cellpadding=0 cellspacing=0>
<tr>
<td width=600 align=center><table width=74% border=0 cellpadding=0 cellspacing=0 >
<tr>
<td width=55% ><span class=text9B> </span><span class=text10Br>*</span><span class=text9g> Company</span>
</td>
<td width=45% ><input class=borderchamp id=nom23 size=30 name=company></td>
</tr>
<tr>
<td height=5></td>
<td></td>
</tr>
<tr>
<td height=5></td>
<td></td>
</tr>
<tr>
<td ><span class=text9B> </span><span class=text10BR>*</span><span class=text9g> Address N°,Road</span> </td>
<td ><input class=borderchamp id=nom4 size=30 name=address></td>
</tr>
<tr>
<td height=5></td>
<td></td>
</tr>
<tr>
<td><span class=text9B> </span><span class=text10BR>*</span><span class=text9g> City
</span>
</td>
<td><input class=borderchamp id=nom5 size=30 name=city></td>
</tr>
<tr>
<td height=5></td>
<td></td>
</tr>
<tr>
<td><span class=text9B> </span><span class=text10BR>*</span><span class=text9g> zip/Code
postal </span> </td>
<td><input class=borderchamp id=nom6 size=8 name=zip></td>
</tr>
<tr>
<td height=5></td>
<td></td>
</tr>
<tr>
<td><span class=text9B> </span><span class=text10BR>*</span><span class=text9g> Pays </span>
</td>
<td><select name=pays class=text7>
<option value="FRANCE" selected>FRANCE</option>
<option value="AFRIQUE DU SUD">AFRIQUE DU SUD</option>
<option value="ALLEMAGNE">ALLEMAGNE</option>
<option value="AUTRICHE">AUTRICHE</option>
<option value="BELGIQUE">BELGIQUE</option>
<option value=5>BRESIL</option>
<option value=6>CANADA</option>
<option value=7>CHINE</option>
<option value=8>CHYPRE</option>
<option value=9>COSTA RICA</option>
<option value=10>CUBA</option>
<option value=11>EGYPTE</option>
<option value=12>ESPAGNE</option>
<option value="ETATS-UNIS">ETATS-UNIS</option>
<option value=14>CORSE</option>
<option value=16>GRECE</option>
<option value=17>GUADELOUPE</option>
<option value=18>GUATEMALA</option>
<option value=19>HONGRIE</option>
<option value=20>ILE MAURICE</option>
<option value=21>INDE</option>
<option value=22>IRAN</option>
<option value=23>IRLANDE</option>
<option value=24>ITALIE</option>
<option value=25>KENYA</option>
<option value=26>LA REUNION</option>
<option value=27>LAOS</option>
<option value=28>LIBAN</option>
<option value=29>MADAGASCAR</option>
<option value=30>MADERE</option>
<option value=31>MALAISIE</option>
<option value=32>MALDIVES</option>
<option value=33>MALTE</option>
<option value=34>MAROC</option>
<option value=35>MARTINIQUE</option>
<option value=36>MEXIQUE</option>
<option value=37>NORVEGE</option>
<option value=38>PEROU</option>
<option value=39>PORTUGAL</option>
<option value=40>RUSSIE</option>
<option value=41>SAINT MARTIN</option>
<option value=42>SENEGAL</option>
<option value=43>SICILE</option>
<option value=44>SRI LANKA</option>
<option value=45>SYRIE</option>
<option value=46>TANZANIE</option>
<option value=47>PRAGUE</option>
<option value=48>THAILANDE</option>
<option value=49>TUNISIE</option>
<option value=50>TURQUIE</option>
<option value=51>LONDRES</option>
<option value=52>VIETNAM</option>
<option value=53>BALEARES</option>
<option value=54>CRETE</option>
<option value=55>BALI</option>
<option value=56>CANARIES</option>
<option value=57>MONACO</option>
<option value=58>CARAIBES</option>
<option value=59>GAMBIE</option>
<option value=60>CAP VERT</option>
<option value=61>SARDAIGNE</option>
<option value=62>NAMIBIE</option>
<option value=63>ROYAUME-UNI</option>
</select></td>
</tr>
<tr>
<td height=5></td>
<td></td>
</tr>
<tr>
<td><span class=text9B> </span><span class=text10BR>*</span><span class=text9g>
Civilité </span></td>
<td><span class=text9B2>
<input name=civil type=radio class=text8B id=radio2 value="b">
Mrs.
<input id=radio3 type=radio value="a" name=civil>
Miss.
<input id=radio4 type=radio value="c" name=civil>
Mr. </span></td>
</tr>
<tr>
<td height=5></td>
<td></td>
</tr>
<tr>
<td><span class=text9B> </span><span class=text10BR>*</span><span class=text9g> Contact </span>
</td>
<td><input class=borderchamp id=nom7 size=30 name=name></td>
</tr>
<tr>
<td height=5></td>
<td></td>
</tr>
<tr>
<td><span class=text9B> </span><span class=text10BR>*</span><span class=text9g> Phone
N° </span> </td>
<td><input class=borderchamp id=nom8 size=10 name=phone></td>
</tr>
<tr>
<td height=5></td>
<td></td>
</tr>
<tr>
<td><span class=text9B> </span><span class=text10BR>*</span><span class=text9g> Portable
N° </span> </td>
<td><input class=borderchamp id=nom9 size=10 name=portable></td>
</tr>
<tr>
<td height=5></td>
<td></td>
</tr>
<tr>
<td><span class=text9B> </span><span class=text10BR>*</span><span class=text9g> E-mail </span>
</td>
<td><input class=borderchamp id=nom10 size=30 name=email></td>
</tr>
<tr>
<td height=5></td>
<td></td>
</tr>
<tr>
<td align=center ><span class=text8>
</span> <input name=submit type=submit class=borderchamp value=Validate name="action" border=0>
</td>
<td align=center > </td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr></table>
<table border=0 cellpadding=0 cellspacing=0 width=600><tr><td height=5></td></tr></table>
<table border=0 cellpadding=0 cellspacing=0 width=600>
<tr><td width=800 align=center>
<table border=0 width=32% cellpadding=4 cellspacing=2>
<tr>
<td width=41% align=center ><span class=text8>Sell<i>More</i></span></td>
<!--td width=25% align=center ><span class=text8>Create</span></td>
<td width=25% align=center ><span class=text8>Update</span></td-->
<td width=43% align=center ><span class=text8>Show me</span></td>
<td width=16% align=center ><a href=#top><img src=./images/fleche-text-haut-r.gif border=0 width=7 height=9></a></td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</body>
</html>[/php]
