[RESOLVED] query results and arrays

[eheia]

I have a simple query below:

$query2 = "SELECT CustomerID FROM Purchased_Leads WHERE CompanyID = '2818' ORDER BY TransactionID DESC LIMIT 0, 41";
$result2 = mysql_query($query2);
$row2 = mysql_fetch_assoc($result2);
$custid = $row2['CustomerID'];

It should return 5 or 6 results depending on the CompanyID. What i need is to then get the results into an array that would look like so:

Array ( [0] => 11111 [1] => 22222 [2] => 33333 [3] => 44444 [4] => 55555 )

I just am unsure of how to go about that. I'm sure i'll probably have to loop through the results but i guess i'm still of unsure how to do this. any ideas?

thanks.

[goldlikesnow]

$query2 = "SELECT CustomerID FROM Purchased_Leads WHERE CompanyID = '2818' ORDER BY TransactionID DESC LIMIT 0, 41";
$result2 = mysql_query($query2);
while ($row2 = mysql_fetch_assoc($result2)) {
$custid[] = $row2['CustomerID'];
}

[eheia]

i knew it had to be that easy. thanks.