par
Invité » 24 mai 2005, 17:34
J'ai un petit probleme d'affichage.
Je voudrais que les images en réponse au SELECT s'affiche ligne par ligne
(3 par lignes). Pour se faire je suis obligé de mettre plein de <BR> pour faire passer mon bloc à la ligne. De plus je n'arrive pas a mettre d'espace entre les differentes tables crée.
<?
$select='SELECT idpeople, photopeople, namepeople, clientpeople, titlepeople, artpeople, marketpeople, mediapeople, creationdatepeople, datepeople FROM people ORDER BY idpeople DESC LIMIT 0,10';
$result=mysql_query($select,$connect);
$total= mysql_num_rows($result);
$n="";
while($row=mysql_fetch_array($result)){
$largeur=3;
$affichage="$total"/"$largeur";
//echo "il y a $affichage lignes";
//echo "il y a $total reponse";
$n==$n++;
$idpeople=$row['idpeople'];
$photopeople=$row['photopeople'];
$namepeople=$row['namepeople'];
$clientpeople=$row['clientpeople'];
$titlepeople=$row['titlepeople'];
$artpeople=$row['artpeople'];
$marketpeople=$row['marketpeople'];
$mediapeople=$row['mediapeople'];
$creationdatepeople=$row['creationdatepeople'];
$datepeople=$row['datepeople'];
J'affiche mes images
if ($n != 4){
echo "<table width=200 height=290 border=1 cellpadding=0 cellspacing=0 align=left>
<tr>
<td height=200 align=center><a href=artcle_people.php?cle=$idpeople><img src=\"$photopeople\" widht=170 border=0></a></td>
</tr>
<tr>
<td height=20><img src=images/spacer.gif width=20 height=15></td>
</tr>
<tr>
<td height=70><span class=peopletexte>Client:</span> <span class=peoplelegend>$clientpeople</span> - <span class=peopletexte>Agency</span>: <span class=peoplelegend>$namepeople</span> - <span class=peopletexte>Title:</span> <span class=peoplelegend>$titlepeople</span> - <span class=peopletexte>Art directors:</span> <span class=peoplelegend>$artpeople </span></td>
</tr>
</table>
" ;
}
else {
echo "
<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
<table width=200 height=290 border=1 cellpadding=0 cellspacing=0 align=left >
<tr>
<td height=200 align=center><a href=artcle_people.php?cle=$idpeople><img src=\"$photopeople\" height=170 border=0></a></td>
</tr>
<tr>
<td height=20><img src=images/spacer.gif width=20 height=15></td>
</tr>
<tr>
<td height=70><span class=peopletexte>Client:</span> <span class=peoplelegend>$clientpeople</span> - <span class=peopletexte>Agency</span>: <span class=peoplelegend>$namepeople</span> - <span class=peopletexte>Title:</span> <span class=peoplelegend>$titlepeople</span> - <span class=peopletexte>Art directors:</span> <span class=peoplelegend>$artpeople </span></td>
</tr>
</table>";
$n=1;}
};
// FIN Affichage newsr CENTRE
?>
Merci de votre aide
J'ai un petit probleme d'affichage.
Je voudrais que les images en réponse au SELECT s'affiche ligne par ligne
(3 par lignes). Pour se faire je suis obligé de mettre plein de <BR> pour faire passer mon bloc à la ligne. De plus je n'arrive pas a mettre d'espace entre les differentes tables crée.
[php]
<?
$select='SELECT idpeople, photopeople, namepeople, clientpeople, titlepeople, artpeople, marketpeople, mediapeople, creationdatepeople, datepeople FROM people ORDER BY idpeople DESC LIMIT 0,10';
$result=mysql_query($select,$connect);
$total= mysql_num_rows($result);
$n="";
while($row=mysql_fetch_array($result)){
$largeur=3;
$affichage="$total"/"$largeur";
//echo "il y a $affichage lignes";
//echo "il y a $total reponse";
$n==$n++;
$idpeople=$row['idpeople'];
$photopeople=$row['photopeople'];
$namepeople=$row['namepeople'];
$clientpeople=$row['clientpeople'];
$titlepeople=$row['titlepeople'];
$artpeople=$row['artpeople'];
$marketpeople=$row['marketpeople'];
$mediapeople=$row['mediapeople'];
$creationdatepeople=$row['creationdatepeople'];
$datepeople=$row['datepeople'];[/php]
J'affiche mes images
[php]
if ($n != 4){
echo "<table width=200 height=290 border=1 cellpadding=0 cellspacing=0 align=left>
<tr>
<td height=200 align=center><a href=artcle_people.php?cle=$idpeople><img src=\"$photopeople\" widht=170 border=0></a></td>
</tr>
<tr>
<td height=20><img src=images/spacer.gif width=20 height=15></td>
</tr>
<tr>
<td height=70><span class=peopletexte>Client:</span> <span class=peoplelegend>$clientpeople</span> - <span class=peopletexte>Agency</span>: <span class=peoplelegend>$namepeople</span> - <span class=peopletexte>Title:</span> <span class=peoplelegend>$titlepeople</span> - <span class=peopletexte>Art directors:</span> <span class=peoplelegend>$artpeople </span></td>
</tr>
</table>
" ;
}
else {
echo "
<br><br><br><br><br><br><br><br><br><br><br><br><br><br><br><br>
<table width=200 height=290 border=1 cellpadding=0 cellspacing=0 align=left >
<tr>
<td height=200 align=center><a href=artcle_people.php?cle=$idpeople><img src=\"$photopeople\" height=170 border=0></a></td>
</tr>
<tr>
<td height=20><img src=images/spacer.gif width=20 height=15></td>
</tr>
<tr>
<td height=70><span class=peopletexte>Client:</span> <span class=peoplelegend>$clientpeople</span> - <span class=peopletexte>Agency</span>: <span class=peoplelegend>$namepeople</span> - <span class=peopletexte>Title:</span> <span class=peoplelegend>$titlepeople</span> - <span class=peopletexte>Art directors:</span> <span class=peoplelegend>$artpeople </span></td>
</tr>
</table>";
$n=1;}
};
// FIN Affichage newsr CENTRE
?>[/php]
Merci de votre aide