MySQL-SELECT into special array

Question

i want to get an array like this:

$autocompletiondata = array(
    3 => 'Hazel Grouse',
    4 => 'Common Quail',
    5 => 'Common Pheasant',
    6 => 'Northern Shoveler',
    7 => 'Greylag Goose',
    8 => 'Barnacle Goose');

out off this SQL-Query:

SELECT id, name FROM tbl_1

Can anyone tell me how to do this?

Marc B · Accepted Answer · 2011-08-09 18:44:27Z

3

$autocompletiondata = array();

$sql = "SELECT id, name FROM tbl_1";
$result = mysql_query($sql) or die(mysql_error());

while($row = mysql_fetch_assoc($result)) {
   $autocompletiondata[$row['id']] = $row['name'];
}

This presumes that you've established a connection to the database, etc...

answered Aug 9, 2011 at 18:44

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

1 Comment

Florian Over a year ago

Thanks for you fast answer :) was exactly what ive been looking for

Pedro Lobito · Accepted Answer · 2011-08-09 19:31:29Z

0

$autocompletiondata =  array(); 

$query  = "SELECT id, name FROM tbl_1";           
$result = mysql_query($query) or die(mysql_error());

while(list($id, $name) = mysql_fetch_array($result))
{
$autocompletiondata[$id] = $name; 
}

easier to read :)

answered Aug 9, 2011 at 19:31

Pedro Lobito

99.8k36 gold badges274 silver badges278 bronze badges

Collectives™ on Stack Overflow

MySQL-SELECT into special array

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related