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

