Query results into an array WITHOUT looping?

eheia

I have been all over google and back today trying to get this figured out and thus far the fail whale is kicking my @$$.

I would love to be able to query a db for multiple rows and just return a multidimensional array that i can use however i see fit. the only solutions i ever find for this always involve looping through all the results and adding to an array. isn't there some magical way to query and just have an array without having to loop?

bpat1434

Nope. All the database abstraction layers I've seen that return result sets will loop through and just do it the old fashioned way:

$result = mysql_query($my_query);
$resultSet = array();
while($row = mysql_fetch_assoc($result)) $resultSet[] = $row;

It's a condensed version, but it's what they do.

Toadums

if i understand cant you just go

$query = "SELECT * FROM `databse`.`table` WHERE field = something"

..??

scrupul0us

Toadums;10919394 wrote:
if i understand cant you just go
$query = "SELECT * FROM `databse`.`table` WHERE field = something"
..??

after you do that and execute it returns a mysql resultant object... bpats solution puts each row into a "normal" array

Weedpacket

While it wouldn't kill anyone to just have a loop (even if you wrote a function and hid the loop in there) if you were using the [man]PDO[/man] interface instead of the old procedural one, you'd have a fetchAll() method which "returns an array containing all of the remaining rows in the result set."

eheia

ok well thanks for your input folks. i didn't figure there was anything like that but, thought i'd ask around just to make very sure.