Bonjour,
j'ai un problème avec mon affichage des données de ma table mysql. Il m'affiche bien le nom de la colonne mais en revanche il ne m'affiche pas les données??
Quelqu'un peut-il m'aider ??
Merci
voici le script (en gras ce qui ne fonctionne pas):
<html>
<FORM method="post" action="page4.php">
<select name="param1" onChange="this.form.submit();">
<option value="insee">insee</option>
<option value="libcom">libcom</option>
</select>
<select name="param2" onChange="this.form.submit();">
<option value="epci">epci</option>
<option value="naf60">naf60</option>
</select>
</form>
<?php
$hostname_local = "localhost";
$database_local = "sirene";
$username_local = "root";
$password_local = "root";
$local = mysql_pconnect($hostname_local, $username_local, $password_local) or die(mysql_error());
?>
<?php
$maxRows_Recordset1 = 10;
$pageNum_Recordset1 = 0;
if (isset($HTTP_GET_VARS['pageNum_Recordset1'])) {
$pageNum_Recordset1 = $HTTP_GET_VARS['pageNum_Recordset1'];
}
$startRow_Recordset1 = $pageNum_Recordset1 * $maxRows_Recordset1;
mysql_select_db($database_local, $local);
$query_Recordset1 = "SELECT * FROM sirene_petit";
$query_limit_Recordset1 = sprintf("%s LIMIT %d, %d", $query_Recordset1, $startRow_Recordset1, $maxRows_Recordset1);
$Recordset1 = mysql_query($query_limit_Recordset1, $local) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
if (isset($HTTP_GET_VARS['totalRows_Recordset1'])) {
$totalRows_Recordset1 = $HTTP_GET_VARS['totalRows_Recordset1'];
} else {
$all_Recordset1 = mysql_query($query_Recordset1);
$totalRows_Recordset1 = mysql_num_rows($all_Recordset1);
}
$totalPages_Recordset1 = ceil($totalRows_Recordset1/$maxRows_Recordset1)-1;
?>
<title></title>
<table border="1">
<tr>
<td><?php echo $param1; ?></td>
<td><?php echo $param2; ?></td>
</tr>
<?php do { ?>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>
<tr>
<td><?php echo $row_Recordset1[$param1]; ?></td>
<td><?php echo $row_Recordset1[$param2]; ?></td>
</tr>
</table>
</HTML>