Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 1 down vote favorite
1

I am trying to create an associative array from MySQL query results. I would like to pull two columns, one contains names, another contains numbers. What I intend to create is something like:

$array = array('maggie'=> 68, 'Joseph' => 21, 'ireen'=> 64);

$dbc = mysqli_connect('localhost', 'root', 'password', 'newbie');
$query = "SELECT fname, eng_end FROM members_records";
$result = mysqli_query($dbc, $query);
while ($array = mysqli_fetch_assoc($result)) {
$data_array[] = $array[];
}

I am unable to construct something sensible between curly braces that can create an array with data from the name column as keys and data from the numbers column as values. Every effort within the curly braces was handsomely rewarded with long and angry PHP parse errors.

How would I proceed from there, or is my foundation too faulty to lead to anything? How best can my goal be accomplished (with minimum code, if possible)?

share|improve this question
shouldn't it be $data_array[] = $array;? Also: $data_array is not defined. – jisaacstone Jun 4 '11 at 1:26

2 Answers

up vote 9 down vote

You probably want something like this:

$dbc = mysqli_connect('localhost', 'root', 'password', 'newbie');
$query = "SELECT fname, eng_end FROM members_records";
$result = mysqli_query($dbc, $query);
$data_array = array();
while ($row = mysqli_fetch_assoc($result)) {
    $data_array[$row['name']] = $row['value'];
}

Substitute your actual column names for 'name' and 'value'.

share|improve this answer
Thanks @dkamins, I added correct DB credentials and made substitutions for column rows and it works like a charm! – Bululu Jun 4 '11 at 2:30
@Bululu Did you intend to "unaccept" this answer? – dkamins Oct 16 '11 at 22:28
up vote 0 down vote

An associative array is created like this:

$a = array('foo' => 'bar', 'color' => 'green');

You can add keys after its creation like this:

$a['someotherkey'] = 'value';
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.