par
pat » 29 oct. 2005, 09:04
Bonjour,
J' ai un probleme avec mon tableau, car plus j' ai de ligne et plus le tableau se décale vers le bas de ma page.
Je ne comprend pas pourquoi.
<?php require_once('../Connections/ConnectionGuide.php'); ?>
<?php
$colname_RSfournmat = "1";
if (isset($HTTP_GET_VARS['mat'])) {
$colname_RSfournmat = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['mat'] : addslashes($HTTP_GET_VARS['mat']);
}
mysql_select_db($database_ConnectionGuide, $ConnectionGuide);
$query_RSfournmat = sprintf("SELECT id_modele, idfourn,Site,idmat, modele , t_fournisseurs.NumFourn, t_fournisseurs.NomFourn, t_modelecaracteristique.idmodele, t_modelecaracteristique.caracteristique FROM t_modele, t_fournisseurs, t_modelecaracteristique WHERE idmat = %s AND t_fournisseurs.NumFourn=t_modele.idfourn AND t_modelecaracteristique.idmodele=t_modele.id_modele ORDER BY idfourn,t_modelecaracteristique.idmodelecar ASC", $colname_RSfournmat);
$RSfournmat = mysql_query($query_RSfournmat, $ConnectionGuide) or die(mysql_error());
$row_RSfournmat = mysql_fetch_assoc($RSfournmat);
$totalRows_RSfournmat = mysql_num_rows($RSfournmat);
$colname_RScarmat = "1";
if (isset($_GET['mat'])) {
$colname_RScarmat = (get_magic_quotes_gpc()) ? $_GET['mat'] : addslashes($_GET['mat']);
}
mysql_select_db($database_ConnectionGuide, $ConnectionGuide);
$query_RScarmat = sprintf("SELECT t_matcar.ordre, t_matcar.matcar, t_matcar.id_mat FROM t_matcar WHERE t_matcar.id_mat=%s ORDER BY t_matcar.ordre ASC", $colname_RScarmat);
$RScarmat = mysql_query($query_RScarmat, $ConnectionGuide) or die(mysql_error());
$row_RScarmat = mysql_fetch_assoc($RScarmat);
$totalRows_RScarmat = mysql_num_rows($RScarmat);
$colmateriel_RSmateriel = "1";
if (isset($_GET['mat'])) {
$colmateriel_RSmateriel = (get_magic_quotes_gpc()) ? $_GET['mat'] : addslashes($_GET['mat']);
}
mysql_select_db($database_ConnectionGuide, $ConnectionGuide);
$query_RSmateriel = sprintf("SELECT t_materiel_compare.id_matcomp, t_materiel_compare.matcom FROM t_materiel_compare WHERE t_materiel_compare.id_matcomp=%s", $colmateriel_RSmateriel);
$RSmateriel = mysql_query($query_RSmateriel, $ConnectionGuide) or die(mysql_error());
$row_RSmateriel = mysql_fetch_assoc($RSmateriel);
$totalRows_RSmateriel = mysql_num_rows($RSmateriel);
?>
<?php do { ?>
<?php
$fourn[]=$row_RSfournmat['NomFourn'];
$modeles[]=$row_RSfournmat['modele'];
$caracteristiques[]=$row_RSfournmat['caracteristique'];
$id_modeles[]=$row_RSfournmat['id_modele'];
$idmateriel=$row_RSfournmat['idmat'];
$site[]=$row_RSfournmat['Site'];?>
<?php } while ($row_RSfournmat = mysql_fetch_assoc($RSfournmat)); ?>
<html>
<head>
<title>Document sans titre</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form action="resultatcoche_comp-mat.php" method="get" name="form1">
<table width="100" border="1" cellpadding="1" cellspacing="0" bordercolor="#6633CC">
<tr>
<td bgcolor="#6633CC" ><div align="center"><font color="#FFFFFF" size="1"><strong>Marque/<br>
Modèle</strong></font> </div></td>
<td bgcolor="#FFFFCC"><div align="center"><strong><font color="#6633CC" size="1">Cocher
pour comparer</font></strong></div></td>
<?php do { ?>
<td bgcolor="#FFFFCC"><div align="center"><font color="#0000FF" size="1">
<?php echo $row_RScarmat['matcar']; ?></font>
<input name="mat" type="hidden" id="mat3" value="<?php echo $row_RSfournmat['idmat']; ?>">
</div>
</td>
<?php } while ($row_RScarmat = mysql_fetch_assoc($RScarmat)); ?>
<?php
$i=0;
while($i<$totalRows_RSfournmat)
{?>
</tr>
<tr>
<td bgcolor="#FFFFFF">
<div align="center">
<p><font color="#000000" size="1"><strong><?php echo $row_RSmateriel['matcom']; ?><br>
<span class="majuscule"><a href="http://<?php echo $site[$i]; ?>" target="_blank"><?php echo $fourn[$i];?></a></span></strong></font><span class="majuscule"></span><font color="#FF0000" size="1"><br>
<?php echo "$modeles[$i]"?></font></p>
</div>
</td>
<td><div align="center"> <input name="choix[]" type="checkbox" id="choix" value="<?php echo $id_modeles[$i]?>">
<input name="mat" type="hidden" id="mat" value="<?php echo $idmateriel ?>"> <A/div>
</td>
<td><div align="center"><font color="#000000" size="1"><?php echo "$caracteristiques[$i]";?></font>
</td><?php $i++;
$j=$i-1;
while($modeles[$i]==$modeles[$j])
{?>
<td><div align="center"><font color="#000000" size="1"><?php echo "$caracteristiques[$i]";?></font></div>
</td><?php
$i++;
$j=$i-1;
if($i==$totalRows_RSfournmat)
{break;}
}
?>
</tr>
<?php echo "<br>";
}
?>
<tr>
<td colspan="50"><input name="imageField" type="image" src="bouton_validerchoix.jpg" width="94" height="28" border="0">
</tr>
</table>
</form>
</p>
</body>
</html>
<?php
mysql_free_result($RSfournmat);
mysql_free_result($RScarmat);
mysql_free_result($RSmateriel);
?>
Bonjour,
J' ai un probleme avec mon tableau, car plus j' ai de ligne et plus le tableau se décale vers le bas de ma page.
Je ne comprend pas pourquoi.
[php]<?php require_once('../Connections/ConnectionGuide.php'); ?>
<?php
$colname_RSfournmat = "1";
if (isset($HTTP_GET_VARS['mat'])) {
$colname_RSfournmat = (get_magic_quotes_gpc()) ? $HTTP_GET_VARS['mat'] : addslashes($HTTP_GET_VARS['mat']);
}
mysql_select_db($database_ConnectionGuide, $ConnectionGuide);
$query_RSfournmat = sprintf("SELECT id_modele, idfourn,Site,idmat, modele , t_fournisseurs.NumFourn, t_fournisseurs.NomFourn, t_modelecaracteristique.idmodele, t_modelecaracteristique.caracteristique FROM t_modele, t_fournisseurs, t_modelecaracteristique WHERE idmat = %s AND t_fournisseurs.NumFourn=t_modele.idfourn AND t_modelecaracteristique.idmodele=t_modele.id_modele ORDER BY idfourn,t_modelecaracteristique.idmodelecar ASC", $colname_RSfournmat);
$RSfournmat = mysql_query($query_RSfournmat, $ConnectionGuide) or die(mysql_error());
$row_RSfournmat = mysql_fetch_assoc($RSfournmat);
$totalRows_RSfournmat = mysql_num_rows($RSfournmat);
$colname_RScarmat = "1";
if (isset($_GET['mat'])) {
$colname_RScarmat = (get_magic_quotes_gpc()) ? $_GET['mat'] : addslashes($_GET['mat']);
}
mysql_select_db($database_ConnectionGuide, $ConnectionGuide);
$query_RScarmat = sprintf("SELECT t_matcar.ordre, t_matcar.matcar, t_matcar.id_mat FROM t_matcar WHERE t_matcar.id_mat=%s ORDER BY t_matcar.ordre ASC", $colname_RScarmat);
$RScarmat = mysql_query($query_RScarmat, $ConnectionGuide) or die(mysql_error());
$row_RScarmat = mysql_fetch_assoc($RScarmat);
$totalRows_RScarmat = mysql_num_rows($RScarmat);
$colmateriel_RSmateriel = "1";
if (isset($_GET['mat'])) {
$colmateriel_RSmateriel = (get_magic_quotes_gpc()) ? $_GET['mat'] : addslashes($_GET['mat']);
}
mysql_select_db($database_ConnectionGuide, $ConnectionGuide);
$query_RSmateriel = sprintf("SELECT t_materiel_compare.id_matcomp, t_materiel_compare.matcom FROM t_materiel_compare WHERE t_materiel_compare.id_matcomp=%s", $colmateriel_RSmateriel);
$RSmateriel = mysql_query($query_RSmateriel, $ConnectionGuide) or die(mysql_error());
$row_RSmateriel = mysql_fetch_assoc($RSmateriel);
$totalRows_RSmateriel = mysql_num_rows($RSmateriel);
?>
<?php do { ?>
<?php
$fourn[]=$row_RSfournmat['NomFourn'];
$modeles[]=$row_RSfournmat['modele'];
$caracteristiques[]=$row_RSfournmat['caracteristique'];
$id_modeles[]=$row_RSfournmat['id_modele'];
$idmateriel=$row_RSfournmat['idmat'];
$site[]=$row_RSfournmat['Site'];?>
<?php } while ($row_RSfournmat = mysql_fetch_assoc($RSfournmat)); ?>
<html>
<head>
<title>Document sans titre</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form action="resultatcoche_comp-mat.php" method="get" name="form1">
<table width="100" border="1" cellpadding="1" cellspacing="0" bordercolor="#6633CC">
<tr>
<td bgcolor="#6633CC" ><div align="center"><font color="#FFFFFF" size="1"><strong>Marque/<br>
Modèle</strong></font> </div></td>
<td bgcolor="#FFFFCC"><div align="center"><strong><font color="#6633CC" size="1">Cocher
pour comparer</font></strong></div></td>
<?php do { ?>
<td bgcolor="#FFFFCC"><div align="center"><font color="#0000FF" size="1">
<?php echo $row_RScarmat['matcar']; ?></font>
<input name="mat" type="hidden" id="mat3" value="<?php echo $row_RSfournmat['idmat']; ?>">
</div>
</td>
<?php } while ($row_RScarmat = mysql_fetch_assoc($RScarmat)); ?>
<?php
$i=0;
while($i<$totalRows_RSfournmat)
{?>
</tr>
<tr>
<td bgcolor="#FFFFFF">
<div align="center">
<p><font color="#000000" size="1"><strong><?php echo $row_RSmateriel['matcom']; ?><br>
<span class="majuscule"><a href="http://<?php echo $site[$i]; ?>" target="_blank"><?php echo $fourn[$i];?></a></span></strong></font><span class="majuscule"></span><font color="#FF0000" size="1"><br>
<?php echo "$modeles[$i]"?></font></p>
</div>
</td>
<td><div align="center"> <input name="choix[]" type="checkbox" id="choix" value="<?php echo $id_modeles[$i]?>">
<input name="mat" type="hidden" id="mat" value="<?php echo $idmateriel ?>"> <A/div>
</td>
<td><div align="center"><font color="#000000" size="1"><?php echo "$caracteristiques[$i]";?></font>
</td><?php $i++;
$j=$i-1;
while($modeles[$i]==$modeles[$j])
{?>
<td><div align="center"><font color="#000000" size="1"><?php echo "$caracteristiques[$i]";?></font></div>
</td><?php
$i++;
$j=$i-1;
if($i==$totalRows_RSfournmat)
{break;}
}
?>
</tr>
<?php echo "<br>";
}
?>
<tr>
<td colspan="50"><input name="imageField" type="image" src="bouton_validerchoix.jpg" width="94" height="28" border="0">
</tr>
</table>
</form>
</p>
</body>
</html>
<?php
mysql_free_result($RSfournmat);
mysql_free_result($RScarmat);
mysql_free_result($RSmateriel);
?>[/php]