mysql_fetch_assoc overwrite array

Question

I have the following codewhich basically seems to be overwriting the same array each time so the output (json) only gives me the last row returned?

Thanks

$structure = mysql_query("SELECT FIELDNAME, DISPLAYNAME from `_PREFS_MAINGRID_`");
$rowsField = array();
while($struct = mysql_fetch_assoc($structure)) {
    $rowsField["columname"] = $struct;
}


$plode = implode("` as `", $rowsField["columname"]);

print json_encode($rowsField);

Amal · Accepted Answer · 2013-09-25 18:48:50Z

4

You aren't pushing the elements into the array in your loop.

Try this:

$rowsField["columname"][] = $struct;

See the documentation for more information.

answered Sep 25, 2013 at 18:48

Amal

76.8k18 gold badges133 silver badges154 bronze badges

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

6 Comments

realtek Over a year ago

That's great! Thank you, it works now... Yes I will check the documentation on that. How can I then implode on this? Thanks

Amal Over a year ago

@user2816451: The same way you did it before

realtek Over a year ago

$plode = implode("` as

", $rowsField["columname"]); seems to return the work "Array" as its an object when printing to the browser rather than the contents of the array? When I did it before I had

FIELDNAME as DISPLAYNAME` for example which is what I wanted, for each row returned

Amal Over a year ago

@realtek: The command isn't exactly the same -- it needs modifications. $rowsField is now a multi-dimensional array. Try doing a echo '<pre>,print_r($rowsField),'</pre>'; and see the what the array contains. And use the correct value in your implode().

realtek Over a year ago

thats great thank you. I re-wrote this using a foreach loop at the moment until I can figure out the implode on it. the printing of the array helped a lot! Thank you

|

Collectives™ on Stack Overflow

mysql_fetch_assoc overwrite array

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related