$sql = "SELECT * FROM PRODUCTS"; $result = mysql_query($sql) or die (mysql_error()); while($row = mysql_fetch_array($result)){ echo $row['products_name']; }