Merci de répondre ,
J e vois que je suis pas assez claire mais je vous donne une partie du code
1 page :
<?php
if ($type!="")
{
$sql = "select a.id_marque,b.marque_long,a.modele,a.profile from logoson_phone a,logoson_phone_marque b,";
$sql.= "logoson_phone_format c,logoson_format d";
$sql.= ($type=="RINGTONE")? ",logoson_phone_format e,logoson_format f":"";
$sql.= " where a.id_marque=b.id_marque and a.id_phone=c.id_phone";
$sql.= " and c.id_format=d.id_format and c.mode='SMS' ";
$sql.= " and d.type='".$type."'";
$sql.= ($type=="RINGTONE")? " and a.id_phone=e.id_phone and e.id_format=f.id_format and e.mode='SMS' and f.type='IMAGE'":"";
$sql.= ($type=="RINGTONE")? " and (d.format='ott' or (d.format='imy' and f.format='EMS'))":"";
$sql.= ($type=="IMAGE")? " and d.format in ('otb','EMS')":"";
$sql.= " group by marque_long,modele,profile order by marque_long, modele,profile";
$res=mysql_query($sql) or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
if (mysql_num_rows($res) == 0)
{
?>
<span id="grosse_surbrillance"><?=L_LS_NO_LOGOSON?></span></p>
<p>
<div id=stats>
$modele = "";
$liste = "";
$fin = FALSE;
?>
<span id="grosse_surbrillance"><?=L_LS_NO_LOGOSON?></span></p></div>
<p>
<?php
}
else
{
?>
<div id=stats>
<?php
$menu_nav="";
$menu_nav=menu_page($sql,$resultat,$_GET['page'],20);
if ($menu_nav!="")
{
?>
<table width='85%' border='0' align="center" cellpadding='0' cellspacing='0'>
<tr><td align="center"><? echo $menu_nav; ?></td></tr>
</table>
</p>
<?php
}
?>
<p>
<table>
<thead>
<tr>
<td><?=L_SRV_LB_MARQ?></td>
<td width="16px"> </td>
<?=($id_profil==PROFIL_ADMIN)? "<td>".L_SRV_LB_MODE."</td>":""?>
<td><?=L_SRV_LB_PRO?></td>
<td width="16"> </td>
<td width="16"> </td>
</tr>
</thead>
<?php
while($result=mysql_fetch_object($resultat))
{
$marque_long=($result['marque_long']==NULL)? 0:$result['marque_long'];
$profile=($result['profile']!=$result['profile'])? TRUE:FALSE;
?>
<tr valign="top">
<td><div id="grosse_surbrillance"><?=strtoupper($result->marque_long)?></div></td>
<?php
$color="green";
if ($color=="green")
{
$texte_statut=L_LS_TEXT_STATUS_OK;
}
?>
<td><img src="<?=$path_images?>icone_<?=$color?>.png" width="16" height="16" border="0" title="<?=$texte_statut?>" alt="<?=$color?>" ></td>
<?=($id_profil==PROFIL_ADMIN)? "<td>".$result->modele."</td>":"" ?>
<td><?=$result->profile?></td>
<td><a href="modification2.php?idmarque=<?="$result->id_marque"?>&marque_long=<?="$result->marque_long"?>&modele=<?="$result->modele"?>" title="<?=sprintf(L_LS_UPDATE_LOGOSON,strtoupper("$result->marque_long"))?>"><img src="<?=$path_images?>icone_editer.png" width="16" height="16" border="0" alt="<?=L_UPDATE?>" ></a></td>
<?php
if ($marque_long==0)
{
?>
<td><a class="secure_action" href="compatibilite.php?idmarque=<?="$result->id_marque"?>&action=supprimer" title="<?=sprintf(L_LS_DELETE_LOGOSON,strtoupper("$result->marque_long"))?>"><img src="<?=$path_images?>icone_supprimer.png" width="16" height="16" border="0" alt="<?=L_DELETE?>" ></a></td>
<?php
}
else
{
?>
<td><a class="secure_action" href="compatibilite.php?idmarque=<?="$result->id_marque"?>&action=archiver" title="<?=sprintf(L_LS_ARCHIVE_LOGOSON,strtoupper("$result->marque_long"))?>"><img src="<?=$path_images?>icone_archiver.png" width="16" height="16" border="0" alt="<?=L_ARCHIVE?>" ></a></td>
<?php
}
print("</tr>");
}
?>
2 page :
$id_marque = $_GET["idmarque"] ;
//requête SQL:
$sql = "select a.id_marque,a.modele,a.profile,b.marque_long from logoson_phone a,logoson_phone_marque b,logoson_phone_format c where a.id_marque=b.id_marque and a.id_marque=".$id_marque;
//exécution de la requête:
$requete = mysql_query( $sql) ;
echo mysql_num_rows($requete)."<hr>";
//echo 'Erreur sur la requete <b>'.$requete.'</b> :<br>'.mysql_error();
//affichage des données:
if( $result = mysql_fetch_object( $requete ) )
{
?>
<form name="insertion" action="modification3.php" method="POST">
<input type="hidden" name="id_marque" value="<?php echo($id_marque) ;?>">
<table>
<tr><td><?=L_SRV_LB_FORM?> : </td><td colspan="2">
<select name="format" >
<option value="0" selected>---</option>
<?
$sql = "SELECT format FROM logoson_format a,logoson_phone_format b WHERE a.id_format=b.id_format and b.mode='SMS'or b.mode='MMS' GROUP BY format";
$res = mysql_query($sql)or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
while ($data = mysql_fetch_array($res)) {
echo '<option value="'.$data[0].'">'.$data['format'];
echo '</option>'."\n";
}
echo '</select>'."\n";
?></td></tr>
<tr><td><?=L_SRV_LB?> : </td><td colspan="2">
<select name="type" >
<option value="0" selected>---</option>
<?
// Récupération des informations triées par ordre alphabétique
$sql = "SELECT type FROM logoson_format a,logoson_phone_format b WHERE a.id_format=b.id_format and b.mode='SMS'or b.mode='MMS' GROUP BY type";
$res = mysql_query($sql)or die('Erreur SQL !<br />'.$sql.'<br />'.mysql_error());
while ($data = mysql_fetch_array($res)) {
echo '<option value="'.$data[0].'">'.$data['type'];
echo '</option>';
}
echo '</select>';
?>
</td></tr>
<tr><td><?=L_SRV_LB_MARQ?> : </td><td colspan="2"><input type="text" name="marque_long" maxlength="35" size="20" value="<?php echo($result->marque_long) ;?>"></td> <br><br>
<tr><td><?=L_SRV_LB_MODE?> :</td><td colspan="2"><input type="text" name="modele" maxlength="35" size="20" value="<?php echo($result->modele) ;?>"></td> <br><br>
<tr><td width="150px"><?=L_SRV_LB_PRO?> : </td><td colspan="3"><textarea name="profile" cols="40" rows="3" onkeyup="limite_texte(this,160)"> <?php echo($result->profile) ;?>