How to add SQL elements to an array in PHP

Question

So this question is probably pretty basic.

I am wanting to create an array from selected elements from a SQL table.

I am currently using:

$rcount = mysql_num_rows($result);

for ($j = 0; $j <= $rcount; $j++)
{
    $row = mysql_fetch_row($result);
    $patients = array($row[0] => $row[2]);
}

I would like this to return an array like this:

$patients = (bob=>1, sam=>2, john=>3, etc...)

Unfortunately, in its current form, this code is either copying nothing to the array or only copying the last element.

I dont really understand what you want to do here, with in the for loop, you are not using the variable j. Please make it more clear, — tkt986
– tkt986, Commented Jan 13, 2011 at 2:28

Jonah · Accepted Answer · 2011-01-13 02:49:41Z

2

Try this instead.

$patients = array();
while ($row = mysql_fetch_row($result)) {
    $patients[$row[0]] = $row[2];
}

If it doesn't work, there's something wrong with your query.

edited Jan 13, 2011 at 2:49

answered Jan 13, 2011 at 2:28

Jonah

10.1k5 gold badges49 silver badges80 bronze badges

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

1 Comment

Daniel Nill Over a year ago

This is much closer to what I want, but I'm trying to avoid having arrays within arrays. Is there someway to modify this so that I don't have Array ( [0] => Array ( [bob] => 5 ) [1] => Array ( [fred] => 1 )), but rather Array([bob]=>5, [fred]=>1)? Thanks.

andrewk · Accepted Answer · 2011-01-13 02:27:46Z

0

you can use print_r()

here is an example

<pre>
<?php
$a = array ('a' => 'apple', 'b' => 'banana', 'c' => array ('x', 'y', 'z'));
print_r ($a);
?>
</pre>

more here http://php.net/manual/en/function.print-r.php

answered Jan 13, 2011 at 2:27

andrewk

3,8814 gold badges33 silver badges38 bronze badges

1 Comment

Daniel Nill Over a year ago

im not sure I understand, won't this just print the elements of the array after I've created it. Furthermore, as I understand it, this wouldn't allow me to select only certain elements from the table to be put in the array.

tkt986 · Accepted Answer · 2011-01-13 02:35:56Z

0

How about this :

while($row = mysql_fetch_assoc($result)){
        $arr_row=array();
        $count=0;
        while ($count < mysql_num_fields($result)) {       
            $col = mysql_fetch_field($result, $count);   
            $arr_row[$col -> $count] = $row[$col -> $count];           
            $count++;
 }

But I not sure if this is what you are looking for, just guessing .. ount

answered Jan 13, 2011 at 2:35

tkt986

1,0264 gold badges17 silver badges25 bronze badges

Collectives™ on Stack Overflow

How to add SQL elements to an array in PHP

3 Answers 3

1 Comment

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Related