Create PHP array from MySQL column, using auto_increment column as index

Question

Much like this previous question, I wish to store a MySQL column in a php array (as opposed to storing by row). However, I want the array indexes to match those of the database's primary key.

For instance, for the following database:

id name
1 Joe
2 Mary
9 Tony

$name['9'] == "Tony"

Is such a thing possible?

Thanks!

Randy · Accepted Answer · 2010-01-15 22:30:35Z

2

$result = mysql_query($q);
while ($row = mysql_fetch_assoc($result)) {
  $array[$row["id"]] = $row["name"];
}

answered Jan 15, 2010 at 22:30

Randy

4,02322 silver badges25 bronze badges

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

3 Comments

Jordan Running Over a year ago

Note that you need to initialize the array before the while loop with $array = array(); or it will throw a notice on the first row. Also, please don't name your variable "$array".

Randy Over a year ago

Pretend it's called $foo then.

David Chouinard Over a year ago

I'm naming $jordan for sure :) Thanks guys!

jspcal · Accepted Answer · 2010-01-15 22:29:39Z

1

yes,

$names = array();
foreach ($rows as $r) {
   $names[$r['id']] = $r['name'];
}

answered Jan 15, 2010 at 22:29

jspcal

52k7 gold badges76 silver badges79 bronze badges

Comments

Paul Dixon · Accepted Answer · 2010-01-15 22:33:23Z

0

A wrapper library can make this easier, e.g. with ADODb:

$array = $db->GetAssoc("select id,name from mytable");

answered Jan 15, 2010 at 22:33

Paul Dixon

302k54 gold badges315 silver badges349 bronze badges

Comments

Nicole · Accepted Answer · 2010-01-15 22:37:40Z

0

Once I have my row results as arrays, I use this method:

function convertArrayToMap(&$list, $attribute, $use_reference=FALSE) {
    $result = array();
    for ($i=0; $i < count($list); $i++) {
        if ($use_reference) $result[$list[$i][$attribute]] = &$list[$i];
        else $result[$list[$i][$attribute]] = $list[$i];
    }
    return $result;
}

And the method call:

$mapOfData = convertArrayToMap($mysql_results, 'ID');

answered Jan 15, 2010 at 22:37

Nicole

33.3k11 gold badges78 silver badges102 bronze badges

Collectives™ on Stack Overflow

Create PHP array from MySQL column, using auto_increment column as index

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related