Mysql Data to Php Arrays

[nderitk]

Hello guys, just assist me with some code fragments simply illustrating how to capture data stored in Mysql databse in php arrays.The data can then be used to generate charts and graphs.

[trq]

$arr = array();
$sql = "SELECT foo, bar FROM tbl"
if ($result = mysql_query($sql)) {
  if (mysql_num_rows($result)) {
    while ($row = mysql_fetch_assoc($result)) {
      $arr[] = $row;
    }
  }
}