mysql get rows

[[email protected]]

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

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?

[PeejAvery]

Nope. MySQL itself can only read one line of data at a time...hence why you have to recurse it.

[[email protected]]

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

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?

while($data[] = mysql_fetch_array($res) ) {}
array_pop($data);

seems to work

[PeejAvery]

But, you're still creating the array one index at a time. You said you didn't want to do that.