Declaring multidimensional array for mysql_fetch_assoc

Question

I am trying to create an array which will follow something like this

array(
    [Matt => 3],
    [Tom => 7]),
    //etc
)

I want this set up so I can use it with a mysql_fetch_assoc() such as

    $i=0;
    while($data = mysql_fetch_assoc($query)){

        $Array[$i] = $data['name'];  // sore name as part of array
        $Array[$i][0] = ($data['number']; // keep number with the name.
        $i++;

    }

This does not work . I was unable to do so with a array_push. Can someone please guide me? Is my array declaration wrong or even important?

Ian Wood · Accepted Answer · 2012-03-28 00:55:48Z

2

while($data = mysql_fetch_assoc($query)){
    $Array[$data['name']] = $data['number']; // keep number with the name.
}

that assumes no duplicate names - which might not be the intention and I've misread your question...

alternatively

while($data = mysql_fetch_assoc($query)){
    $Array[] = array($data['name'] => $data['number']); // keep number with the name.
}

The latter is something that you can do with pdo fetchAll(PDO::FETCH_ASSOC); see here

answered Mar 28, 2012 at 0:55

Ian Wood

6,5736 gold badges36 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Phil Over a year ago

PDOStatement::fetchAll() won't produce an associative array like that but I think your second example is probably what the OP wants. +1

Ian Wood Over a year ago

@Phil PDO will if you use the PDO::FETCH_ASSOC const. on fetchAll you will get a numerically indexed array of tuples which contains an associative array of the fields and their values.

Phil Over a year ago

Yes, but it won't give you Matt => 3. It will give you name => Matt, number => 3

Ian Wood Over a year ago

yeah - think that oversight means bed-time :P BUT easier to work with in most cases...

Ian Wood Over a year ago

make sure you accept the answer mattyd. it helps your reputation when asking future questions.

|

Phil · Accepted Answer · 2012-03-28 00:54:36Z

0

I can't quite tell exactly what you want but does this help?

$array = array();
while ($data = mysql_fetch_assoc($query)) {
    $array[$data['name']] = $data['number'];
}

This will produce an array like the following (print_r style)

Array
(
    [Matt] => 3,
    [Tom]  => 7
)

answered Mar 28, 2012 at 0:54

Phil

166k25 gold badges265 silver badges269 bronze badges

Collectives™ on Stack Overflow

Declaring multidimensional array for mysql_fetch_assoc

2 Answers 2

6 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related