Re: PEAR DB getAssoc()

Pete Morganic <pete@daffodil.uk.com> · Fri, 11 Jul 2003 10:57:48 +0100



$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