mysql get rows

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?

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

Quote:

---

Originally Posted by [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

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?

---

Code:

---

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

---

seems to work :)

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