Display data from MySQL with PHP without knowing the field name

[phppaper]

How can you display all of the records from MySQL table with PHP without knowing the field name??

 

Anyone can give you a sample code??

 

Thanks!

[trq]

Assuming $row holds your record.

 

foreach ($row as $r) {
  echo $r;
}

[phppaper]

But how can you display each field as a cell of a table. (with one row table for one row of record)??

[trq]

As you echo each field add the required html. eg;

 

while ($row = mysql_fetch_assoc($result)) {
  echo '<tr>';
  foreach ($row as $r) {
    echo '<td>' . $r . '</td>';
  }
  echo '</tr>';
}

[ignace]

$query = 'SELECT * FROM users';
$result = mysql_query($query, $connection);
$fieldCount = mysql_num_fields($result);
for ($i = 0; $i < $fieldCount; ++$i) {
    echo mysql_field_name($result, $i), ', ';
}

 

Outputs:

id, username, password, email_address