1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
$liste1=mysql_query("select max(k) as idmax,min(lu) as idlu,max(tamp) as idtamp,max(ka) as idde from `mp` where `kde`='".$_SESSION['mbid']."' && `delde`!='1' group by `ka` order by `idmax` desc");
while($liste=mysql_fetch_array($liste1)){
$listepseudo=mysql_fetch_array(mysql_query("select `pseudo`,`sexe` from `user` where `k`='".$liste['idde']."' "));
echo'<li';if($liste['idlu']>='1') echo ' class="mp-cla8a"';echo'><a href="'.$URL['messagerie'].'?go=sup&id='.$liste['idde'].'&id2='.$_SESSION['mbid'].'" onclick="if (!confirm(\'Supprimer ?\')) return false;"><img src="'.$URL['dizimg'].'/mp-ligne1.png" class="mp-cla9" /></a><a href="http://www.***.com/messagerie.html?go=lire&lirede='.$liste['idde'].'&lirea='.$_SESSION['mbid'].'">'.date('d/m à H:i',$liste['idtamp']).' - <b>'.getsql($listepseudo['pseudo']).'</b> - <img src="'.$URL['dizimg'].'/sexe'.$listepseudo['sexe'].'.png" /> ';if($liste['idlu']>='1') echo'(lu)'; else echo'(non lu)';echo'</a></li>'."\n".'';
}
$liste1=mysql_query("select max(k) as idmax,min(lu) as idlu,max(tamp) as idtamp,max(kde) as idde from `mp` where `ka`='".$_SESSION['mbid']."' && `dela`!='1' group by `kde` order by `idmax` desc");
while($liste=mysql_fetch_array($liste1)){
$listepseudo=mysql_fetch_array(mysql_query("select `pseudo`,`sexe` from `user` where `k`='".$liste['idde']."' "));
echo'<li';if($liste['idlu']>='1') echo ' class="mp-cla8a"';echo'><a href="'.$URL['messagerie'].'?go=sup&id='.$liste['idde'].'&id2='.$_SESSION['mbid'].'" onclick="if (!confirm(\'Supprimer ?\')) return false;"><img src="'.$URL['dizimg'].'/mp-ligne1.png" class="mp-cla9" /></a><a href="http://www.***.com/messagerie.html?go=lire&lirede='.$liste['idde'].'&lirea='.$_SESSION['mbid'].'">'.date('d/m à H:i',$liste['idtamp']).' - <b>'.getsql($listepseudo['pseudo']).'</b> - <img src="'.$URL['dizimg'].'/sexe'.$listepseudo['sexe'].'.png" /> ';if($liste['idlu']>='1') echo'(lu)'; else echo'(non lu)';echo'</a></li>'."\n".'';
} |
Partager