[PHP-DB] Failed to query correctly.

[Denny]

Hi,

I got this problem when i tried to do a sql query and print the ouput. But the script 
below always failed to return the first row of the records. But i do a manual query, i 
got the results i wanted.


Thanks,
Denny


    $query="SELECT * from $tbl ";

    $result=mysql_query($query);

    
    while ($line = mysql_fetch_row($result)) {
       while(list($col_name, $col_value) = each($line)) {
        print "\t\t<td><p align=center>$col_value</p></td>\n";
      }

     }