Automatically display all data in a table?

MySQL / PHP

[TheVanWarehouse]

Is there a way to automatically display all field names and data in a table (MySQL using PHP) - without having to specify field names etc?

I remember doing this in Access and found it useful when examining a new database.

[Demaestro]

select * from table_name

[brotherhood of LAN]

Elaborating a little...

$query = mysql_query('SELECT * FROM table_name'); 
$start = FALSE; 
echo '<table border="1">'; 
while($row = mysql_fetch_array($query,MYSQL_ASSOC)) 
{ 
if(!$start) 
{ 
$start = TRUE; 
echo '<tr>'; 
foreach($row as $key => $value) 
 echo '<th>'.$key.'</th>'; 
echo '</tr>'; 
} 
echo '<tr><td>'.implode('</td><td>',$row).'</td></tr>'; 
} 
echo '</table>';

[Demaestro]

thanks brother,

I mis-read it, thought it said ".... from a table"

[edited by: Demaestro at 4:12 pm (utc) on May 27, 2009]