Show all records from mysql table with PHP

• To display all records from mysql table with php.
• Show mysql table records.
• List all records from mysql table.
• Fetch mysql table records with php.

This script displays all records from a mysql table.

Script

$sql = mysql_query("select * from products");

while($row=mysql_fetch_array($sql)){
   
  foreach($row as $key=>$value){
     echo $value;
  }

  echo $row['product'] . ', ';
}

Output

nokia 6600, nokia E63, nokia 9300, nokia 9600, nokia e71,