[SOLVED] mysql

[40esp]

I bet this is a common question, but i cant find the answer.

 

How do I display all records in a database?

 

Can I get a loop example?

[.josh]

 

$conn = mysql_connect("localhost",'dbname','dbpass');
$db = mysql_select_db("dbname", $conn);

$sql = "select * from table";
$result = mysql_query($sql, $conn);

while ($list = mysql_fetch_assoc($result)) {
   foreach ($list as $key => $val) {
      echo "$key : $val <br />";
   }
   echo "<br />";   
}

[40esp]

Thanks =]