Hi,
i'm trying to first, display with a loop all the tables in my db and secondly, display some information from each tables
<?
// DB Connect
$db = mysql_connect('localhost', 'xxxxx', 'xxxxx');
mysql_select_db('xxxxx',$db);
?>
...
<?
// Variable
$colorCounter = 0;
// Request
$sql = @mysql_query('SHOW tables FROM visionclient_ca LIKE "f%"');
$result = mysql_query($sql) or die('Erreur : '.mysql_error());
// Create List
while ($row = mysql_fetch_array($result)) {
if($colorCounter%2 == 0){
$colorCounter++
?>
<tr height="34" valign="middle" bgcolor="#E5E5E5">
<td width="20" align="center"><img src="images/i-form.gif"></td>
<td><span class="textTableColor"><?=$row['tableID']?></span><br><span class="textTable"><?=$row['tableComment']?></span></td>
<td width="60" align="center"><span class="textTable">05/12</span></td>
<td width="200" align="center"><a href="#"><img src="images/b-view.gif" border="0"></a> <a href="#"><img src="images/b-edit.gif" border="0"></a> <a href="#"><img src="images/b-send.gif" border="0"></a></td>
<td width="150" align="right"><span class="textTable"><?=$row['tableLastModDate']?><br>par </span><span class="textTableColor"><?=$row['tableLastModUser']?></span></td>
</tr>
<?
}else{
$colorCounter++
?>
<tr height="34" valign="middle" bgcolor="#F9F9F9">
<td width="20" align="center"><img src="images/i-form.gif"></td>
<td><span class="textTableColor"><?=$row['tableID']?></span><br><span class="textTable"><?=$row['tableComment']?></span></td>
<td width="60" align="center"><span class="textTable">05/12</span></td>
<td width="200" align="center"><a href="#"><img src="images/b-view.gif" border="0"></a> <a href="#"><img src="images/b-edit.gif" border="0"></a> <a href="#"><img src="images/b-send.gif" border="0"></a></td>
<td width="150" align="right"><span class="textTable"><?=$row['tableLastModDate']?><br>par </span><span class="textTableColor"><?=$row['tableLastModUser']?></span></td>
</tr>
<?
}
}
?>
please, need help
i hope you'll understand what i wanna do
Steve
