help with array

[UKlee]

hi I am trying to pull data from mysql db and break this into an array that I can then pull certain bits of data from, hope this makes sence to someone 🙂

$dbh=mysql_connect("localhost", "$username", "$code") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("$database");
$query = mysql_query("SELECT * FROM `allflights` WHERE id='$callsign' ORDER BY date DESC LIMIT 5") or die (mysql_error());

I would like to place like data for say these five items so I can have them stored in arrays and then select the different data as needed from each one.

thanks in advance if you can help and if not thanks for looking .

Lee

[barand]

$data = array();

$dbh=mysql_connect("localhost", "$username", "$code") or die ('I cannot connect to the database because: ' . mysql_error()); 
mysql_select_db ("$database"); 
$query = mysql_query("SELECT * FROM `allflights` WHERE id='$callsign' ORDER BY date DESC LIMIT 5") or die (mysql_error()); 

while ($row = mysql_fetch_assoc($query)) {
        $data[] = $row;
}