sorry not sure if i can publish a question on mysql here...

on a query that returns n number of rows can i do it in a single statement instead of looping through...

right now this is what i do

Code:
while($data = mysql_fetch_array($res) )
{
     $temp['name'][] = $data['name'];
     $temp['state'][] = $data['state'];
     $temp['street'][] = $data['street'];
    $temp['number'][] = $data['number'];
    
}
cant i have mysql automatically put them all in an array for me?