How to create a simple PHP array from a result in a MySQL query?

Question

I have a MySQL database that has a column with a bunch of descriptions. I want those in a PHP array imitating this:

$Description[0] = "Here's a description";
$Description[1] = "Here's another description";
$Description[2] = "Wow, many descriptions";
$Description[3] = "Another one";
$Description[4] = "They just keep going";
...etc

I'm struggling with the while loop logic to make this happen though. Help!

and what have you tried

Satya
– Satya

2015-08-30 03:43:36 +00:00
Commented Aug 30, 2015 at 3:43 — Satya
– Satya, Commented Aug 30, 2015 at 3:43
possible duplicate of How do I create this array in PHP?

scottydelta
– scottydelta

2015-08-30 04:13:17 +00:00
Commented Aug 30, 2015 at 4:13 — scottydelta
– scottydelta, Commented Aug 30, 2015 at 4:13

satroy · Accepted Answer · 2015-08-30 04:09:24Z

0

$result = mysql_query(...);
$Description = array();
while ($row = mysql_fetch_array($result)) {
    array_push($Description, $row["columnyouwant"]);
}

answered Aug 30, 2015 at 4:09

satroy

1169 bronze badges

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

Comments

Nunser · Accepted Answer · 2015-08-30 05:21:20Z

0

$Description = array();
$result = mysql_query(......);
while ($row = mysql_fetch_array($result))
{
    $Description[] = $row;
}
// echo print_r($Description);

edited Aug 30, 2015 at 5:21

Nunser

4,5228 gold badges27 silver badges37 bronze badges

answered Aug 30, 2015 at 4:40

Kishan Kikani

411 silver badge13 bronze badges

Comments

Vahid Alvandi · Accepted Answer · 2015-08-30 03:49:45Z

-1

hi very simple...

foreach ($Description as $value) {
   echo $value;
}

answered Aug 30, 2015 at 3:49

Vahid Alvandi

61210 silver badges18 bronze badges

1 Comment

Cherries0nTopGaming Over a year ago

Sorry, I guess I should've specified. I just want to pull the information from my MySQL database and store the values into the $Description array, not echo them out. I don't have the values in the array yet, that's what I need help with. A While loop to pull those from my database and plop them in there.

Collectives™ on Stack Overflow

How to create a simple PHP array from a result in a MySQL query?

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related