Query result column to array
| From: | Christopher Watson | Date: | Wed, 30 Aug 2006 14:37:29 +0000 |
| Subject: | Query result column to array | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-241233@lists.php.net to get a copy of this message | ||
I'm looking for a native method for taking all of the values from one
column of a query result and creating an array of those values.
Procedurally, I'd tend to want to do this:
<?php
$my_id_array = array();
$query_result = $_DB->query("SELECT my_id FROM my_table");
while ($row = $query_result->fetchRow())
$my_id_array[] = $row['my_id'];
?>
Heck, ColdFusion has the ValueList function which does exactly what I
want (of course, it returns a delimited list [string], not a native
array, but the one-step method is there). Is there anything in
PHP-land that does that? Or am I pretty much stuck using some
variation of the code above?
Christopher Watson
Principal Architect
The International Variable Star Index (VSX)
http://vsx.aavso.org