Display output from SQL query in a dynamic table?

[bioinfomatic]

Hi,
Does anyone know how i can display the results of a SQL query in a table. Obviously the table would need to be dynamic as the query could return different number of rows each time. At the moment the results of the query are stored in an array. If anyone can help it would be appreciated as i can't get nowhere with creating a dynamic table.

Thanks

 

[Rieekan]

Something like this:

$sth->execute() or die "Cannot execute";
while (my (@rows) = $sth->fetchrow_array())
{
    print "<tr><td>$row[0]</td>"; #etc for all rows
    print "</tr>";
}
$sth->finish;

- Rieekan