1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
| echo "
<div algin=center><font size=3>Suivi de projet</font></div>
<table align=center>
";
$chaine="SELECT * FROM projets ORDER BY id DESC";
$request = MYSQL_QUERY($chaine);
$nb_proj = @MYSQL_NUMROWS($request);
$colonnes = mysql_query("SHOW COLUMNS FROM projets;");
$nbcol = @MYSQL_NUMROWS($colonnes);
echo"
<table border=1>
<tr>";
while($colonnes_array = mysql_fetch_assoc($colonnes))
{
$$colonnes_array['Field']=mysql_result($request,$colonnes_array);
echo "<th scope='col'>".$colonnes_array['Field']."</th>";
}
echo"</tr>";
$i=0;
echo $nb_proj;
while ($i<$nb_proj)
{
echo"<tr>";
while($colonnes_array = mysql_fetch_assoc($colonnes)) //j'ai essayé avec while (j<21), meme résultat
{
echo "<td> r ".mysql_result($i,$request,$colonnes_array['Field'])."</td>";
$j++;
}
echo"</tr>";
$i++;
} |
Partager