[PHP-DB] Re: PEAR DB getAssoc()

[Pete Morganic]

$sql = ' select contact_id, contact_name from contacts';

$contacts = $db->getAssoc($sql);

also try getAll which will give u a different result
$contacts = $db->getAll($sql);
pete

Jacob Marble wrote:
Hey all-
    Could someone give an example of how to use the DB_Common::getAssoc()
function?  I'm trying to get an table into an array, and var_dump() shows
that the array is not associative.  Here's the code:
$sql = "select * from sr_names";
$table = $db->getAssoc($sql);
echo var_dump($table);
    And here's the output:

array(1) {
  [1]=>
  array(16) {
    [0]=>
    string(5) "Jacob"
    [1]=>
    string(6) "Marble"
    [2]=>
    NULL
<etc...>
    As I understand it, an associative array should return something more
like:
array(1) {
  [1]=>
  array(16) {
    ['firstname']=>
    string(5) "Jacob"
    ['lastname']=>
    string(6) "Marble"
    ['email']=>
    NULL
<etc...>
    Or am I showing off my newness... ;-)  Any help greatly appreciated!!

Jake

LandEZ




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php