How can i get data from this?

[Sayian]

I have assigned an array from a query like this

$blast_sql = "SELECT `from`, `time`, `blast` FROM `shocc_blasts` WHERE `to` = '$profile_name' ORDER BY `time` DESC";
$blast_query = mysql_query($blast_sql) or die(mysql_error());
if(mysql_num_rows($blast_query)) {
	while($row = mysql_fetch_assoc($blast_query)) {
		$blasts[] = $row;
	}

Now , if i do a print_r of $blasts i can see the data in the array

Array ( [0] => Array ( [from] => Shocc [time] => 1125871034 [blast] => dfsdf
dfdsf

sdfsdfd ) [1] => Array ( [from] => Shocc [time] => 1125870547 [blast] => testing ... ) )

I need to get the FROM variable above ... using syntax $blasts[from] yeilds no results ...

What am i doing wrong?

[madwormer2]

$blasts[0][from] or $blasts[1][from] depending on which one you want.

[Sayian]

Thanks for your post .. see thats the problem , i need all of them , but in a advanced numeric output ..

for instance

[0] from
[1] from
[2] from

ect .. i need the results to print for every one

[Sayian]

i have tried
echo($blasts[][from]) to echo out all the from's

but i only get
Fatal error: Cannot use [] for reading