Dynamic Content in PHP array

Question

This should be a quick one.

I'm pulling a list of id's and I need to place them in an array.

Here is my php code to get the list of id's

$get_archives = mysql_query("SELECT * FROM archive WHERE user = '$email'  ");
while ($row = mysql_fetch_assoc($get_archives)) {
$insta_id = $row['insta_id'];

    $insta_id = "'" . $insta_id."',";

echo $insta_id;

    };

This echo's a list of id's that looks like this: '146176036','136514942',

Now I want to put that list into an array. So i tried something like this:

    $y = array($insta_id);

However that isn't working. Any suggestions?

flowfree · Accepted Answer · 2012-05-25 03:58:03Z

1

$y = array();
while ($row = mysql_fetch_assoc($get_archives)) {
  $y[] = $row['insta_id'];
}

answered May 25, 2012 at 3:58

flowfree

16.5k12 gold badges55 silver badges79 bronze badges

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

Comments

Mr Coder · Accepted Answer · 2012-05-25 03:57:59Z

0

$myArray = array();

    $get_archives = mysql_query("SELECT * FROM archive WHERE user = '$email'  ");
    while ($row = mysql_fetch_assoc($get_archives)) {
    $insta_id = $row['insta_id'];

        $insta_id = "'" . $insta_id."',";


        $myArray[] =$insta_id;

        };

answered May 25, 2012 at 3:57

Mr Coder

8,1965 gold badges49 silver badges74 bronze badges

Comments

user557846 · Accepted Answer · 2012-05-25 03:58:13Z

0

did you mean like this: ?

$insta_id=array();
while ($row = mysql_fetch_assoc($get_archives)) {
$insta_id[] = $row['insta_id'];
}

answered May 25, 2012 at 3:58

user557846

Comments

Sampson · Accepted Answer · 2012-05-25 03:59:09Z

0

Create an array, and push the values into it:

$values = array();

while ( $row = mysql_fetch_assoc( $get_archives ) ) {
  array_push( $values, $row['insta_id'] );
}

answered May 25, 2012 at 3:59

Sampson

269k76 gold badges546 silver badges570 bronze badges

Collectives™ on Stack Overflow

Dynamic Content in PHP array

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related