[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Problem with fetching values...
From:       Michelle Konzack <linux4michelle () tamay-dogan ! net>
Date:       2008-12-28 16:44:21
Message-ID: 20081228164421.GU30865 () tamay-dogan ! net
[Download RAW message or body]


OK, Now I have gotten something...

----[ '~/.tdphp-vserver/includes/10_electronica_admin.inc' ]------------
<snip>
#  while ($DB_list=db_fetch_array($DB_result)) {
#    $output .= "    <li><a href=\"/?what=admin&where=" . $VAL2 . "&action=edit&
#    if ($_COOKIE[$VAL2 . '_desc_short'] == 'show') {
#      $output .= "<dt />" . $DB_list['desc_short'];
#    }
#    $output .= "</li>\n";
#  }
  echo "<pre>\n";
  while ($DB_list=db_fetch_array($DB_result)) {
    print_r ($DB_list);
  }
  echo "</pre>\n";
  exit();
<snip>
------------------------------------------------------------------------

which output:

----[ STDIN ]-----------------------------------------------------------
Array
(
    [0] => 1
    [1] => 24V DC Modular ATX PSU
    [2] => foo
)
Array
(
    [0] => 2
    [1] => 24V DC Modular Solar-Wind-Charger and Distributor
    [2] => foo
)
Array
(
    [0] => 3
    [1] => 24V DC Multichemistry Charger
<snip>
------------------------------------------------------------------------

So, PostgreSQL catch the array by "name" and MySQL use the position?

But positional values do not work, since the sequence can change...

How can I get the db_fetch_array($DB_result) to give me the name instead
the numerical position?

I need:

Array
(
    [serno] => 1
    [name] => 24V DC Modular ATX PSU
    [dec_short] => foo
)


Thanks, Greetings and nice Day/Evening
    Michelle Konzack
    Systemadministrator
    24V Electronic Engineer
    Tamay Dogan Network
    Debian GNU/Linux Consultant


-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
<http://www.tamay-dogan.net/>               <http://www.can4linux.org/>
Michelle Konzack   Apt. 917                  ICQ #328449886
+49/177/9351947    50, rue de Soultz         MSN LinuxMichi
+33/6/61925193     67100 Strasbourg/France   IRC #Debian (irc.icq.com)

["signature.pgp" (application/pgp-signature)]

[prev in list] [next in list] [prev in thread] [next in thread]