[RESOLVED] Simple query into array...

[lowlyhack]

I am trying to extract x number of recently searched terms and display them. I don't know why I am getting this result:

<?php
$query = "SELECT * FROM SEARCH_TERMS ORDER BY SEARCH_TIME";
$result = mysql_query($query);
while($arr = mysql_fetch_assoc($result)){
   extract($arr);
   echo "$arr | ";
}
?>

Result:
Array | Array | Array | Array |

Why am I only getting "Array" on everything and not the actual values?

[dagon]

Why am I only getting "Array" on everything and not the actual values?

because you are trying to echo an array.

read the manual entry for the extract function.

of just use the $arr array

echo $arr['foo'];

or whatever your field names are.

[lowlyhack]

But when I echo $result I get nothing

[dagon]

read my response again you don't echo $result

[tapos]

You need to know more about echo statement. See here

[lowlyhack]

thanks, appreciated!