Array question...

Discussion in 'PHP' started by x0x, Sep 26, 2009.

0
  1. #1
    $icn = $DB->fetch("SELECT icon FROM $tab[fam] WHERE id='$id'", __FILE__, __LINE__);
    $icn2 = $DB->fetch("SELECT icon FROM $tab[fam] WHERE id='$pid'", __FILE__, __LINE__);


    Would it be possible to make that into one array instead of two queries?


    Like $icn['first'] and $icn['second'], would be the same query but 'first' => WHERE id='$id' and second => WHERE id='$pid'

    Just trying to make my code more compact...
     
    x0x, Sep 26, 2009 IP
  2. ThePHPMaster

    ThePHPMaster Well-Known Member

    Messages:
    737
    Likes Received:
    52
    Best Answers:
    33
    Trophy Points:
    150
    #2
    Try:

    $icn = $DB->fetch("SELECT icon FROM $tab[fam] WHERE id='$id' OR id='$pid'", __FILE__, __LINE__);
    print_r($icn);
     
    ThePHPMaster, Sep 26, 2009 IP
  3. x0x

    x0x Well-Known Member

    Messages:
    510
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    110
    #3
    How do I know which one to pull? Let's say I want to pull the $id one?
     
    x0x, Sep 27, 2009 IP
  4. dweebsonduty

    dweebsonduty Active Member

    Messages:
    131
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    71
    Digital Goods:
    1
    #4
    do a var_dump($icn) and that will tell you what is what.

    it may say
    [0]->"blah"
    [1]->"blah1"

    Then $icn[0]=blah and $icn[1]=blah1

    it is harder to explain then I thought.
     
    dweebsonduty, Sep 27, 2009 IP
  5. ThePHPMaster

    ThePHPMaster Well-Known Member

    Messages:
    737
    Likes Received:
    52
    Best Answers:
    33
    Trophy Points:
    150
    #5
    The first item in the array is the id and so on. MySQL returns columns the same order you specified them in the query.
     
    ThePHPMaster, Sep 28, 2009 IP