dual array?

[MasterACE14]

Hello,

 

I have the following MySQL query selecting data from 2 tables:

        $P1itemWq = Database::query("SELECT * FROM `ca_items`, `ca_shop` WHERE `ca_items`.`itemid` = `ca_shop`.`id` && `ca_items`.`ownerid`='".$P1['id']."' && `ca_shop`.`type`='weapon' ");
        $P1itemW = Database::fetch_array($P1itemWq);

 

However when I try to display the query data after fetch'ing it into an array, I appear to get 2 arrays displayed which have the same values?

        // test
        $P1wepCount = Database::num_rows($P1itemWq);
        if($P1wepCount > 0)
        {
        foreach($P1itemW as $key => $val)
        {
            echo $key." -> ".$val."<br />";
        }
        }
        exit;

 

result:

0 -> 6

id -> 15

1 -> 1

ownerid -> 1

2 -> 15

itemid -> 15

3 -> 15

4 -> Club

name -> Club

5 ->

description ->

6 -> 10

price -> 10

7 -> 2

power -> 2

8 -> weapon

type -> weapon

 

thanks in advance!

[Adam]

That's because you're using fetch_array(). If you wish to return only the associative array use fetch_assoc(), or for the numeric array use fetch_row() .. That's assuming of course the DB class you're using has those methods.

[MasterACE14]

That's because you're using fetch_array(). If you wish to return only the associative array use fetch_assoc(), or for the numeric array use fetch_row() .. That's assuming of course the DB class you're using has those methods.

ah ha! I've just added a fetch_assoc(); method to my DB class and it's working!

 

thank you kindly! much appreciated

[miltonstephen2010]

Thanks MrAdam, It also working with me.

[Adam]

No problem