IT & Programming

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,

Leave A comment

Email address is optional and will not be published. Only add email address if you want a reply from blog author.
Please fill required fields marked with *