Drupal 5: Querying the Drupal database and fetching all the results in an associative array
Here’s a code snippet to show how to execute a query and fetch all the results into an associative array:
<?php
// create the SQL in a string
$sql = "
select *
from {node} n
where n.status = '1'";
// execute the query
$resource = db_query($sql);
// loop through the resource and fetch the rows
$results = array();
while ($row = db_fetch_array($resource)) $results[] = $row;
// show the results
echo "<pre>" . print_r($results, TRUE) . "</pre>";
?>