Hi,
I just looked over the code I sent and I saw that there is a bug there. Here's the 
corrected version. This one is tested and it
works fine

$query="SELECT * from $tbl";
$result=mysql_db_query($db,$query) or mysql_die();
echo "<table>";
while ($line = mysql_fetch_assoc($result)) {
 if (!$firstrow){
 echo "<tr>";
 while(list($col_name, $col_value) = each($line)) {
  print "\t\t<td><p align=center>$col_name</p></td>\n";
  $firstrow.="\t\t<td><p align=center>$col_value</p></td>\n";
 }
 echo "</tr>";
 echo "<tr>$firstrow</tr>";
 }
 else{
 echo "<tr>";
 while(list($col_name, $col_value) = each($line)) {
  print "\t\t<td><p align=center>$col_value</p></td>\n";
 }
 echo "</tr>";
 }
}
echo "</table>";

Hope this helps

Dobromir Velev
Web Developer
http://www.websitepulse.com/



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to