[RESOLVED] Display both the filename and the value in query results

[mrgrammar]

$q = "SELECT * FROM tablename WHERE primary = 1";
$results = $mysqli->query($q);

What is the best way to show both the fieldname and value for each record?

[mrgrammar]

It took me a bit, but I found what I was looking for.

$q = "SELECT * FROM tablename WHERE primary = 1"; 
$results = $mysqli->query($q); 
while($row = $results->fetch_assoc()){
	foreach ($row as $k=>$v)
	    {
	        echo '<p>'.$k.': '.$v.'</p>';
	    }
}