Re: [PHP] make keys of a associative array DB field names?

[Paul Novitski]

At 12:54 PM 4/14/2006, Bing Du wrote:
Would anybody remind me how this should be achieved?
This returns all the names of the fields.

while( ($f = odbtp_fetch_field( $qry )) ) {
        echo $f->name . "\n";
    }

This returns the query results:

while( ($rec = odbtp_fetch_array($qry)) ) {
   foreach ($rec as $var) {
        echo "$var\n";
   }
}

How should I connect them together?  Say, the fields are 'name', 'age',
'score'.  I want to print out $rec['name'], $rec['age'] and $rec['score']
rather than using $rec[0], $rec[1] and $rec[2].


Here's one way:

        $oHandle = mysql_query($sSQL);

                if (!$oHandle)
                {
                        // error trapping goes here
                }

        // cycle through the records:
        while ($aDataRow = mysql_fetch_array($oHandle, MYSQL_ASSOC))
        {
                // cycle through the fields in each record:
                foreach ($aDataRow as $sField => $sValue)
                {
                        // $sField is the field name
                        // $sValue is the field value
                }
        }

Paul 

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