PHP MySQL Get Column Names When Repeating All Records

Question

$query = mysql_query("SELECT * FROM mytable"); while ($row = mysql_fetch_assoc($query)) { //How to echo column names and values here? } 

Is it possible to repeat table column names and values ​​when repeating throughout the table in a while ?

Answer 1

You can use foreach loop

 $query = mysql_query("SELECT * FROM mytable"); while ($row = mysql_fetch_assoc($query)) { foreach($row as $key => $value) { print "$key = $value <br />"; } } 

Answer 2

 $query = mysql_query("SELECT * FROM mytable"); while ($row = mysql_fetch_assoc($query)) { print_r($row); } 

Answer 3

try it. column_name is the same u name used in the table

 echo $row['column_name'];