Get Column All Values in One Array Using php [duplicate]

Question

I have a table my_entity_data in that i have a column parentproduct_id

I want to get all values of that column in side one array

<?php
    $result = mysql_query("SELECT parentproduct_id FROM my_entity_data");
    $storeArray = Array();
    while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
         $storeArray[] =  $row['parentproduct_id'];  
    }
    for ($i=0; $i < 10; $i++) { 
    echo $storeArray[i];
    }
?>

But no use Any thing wrong i did here ?

And i am running this code in Magento CE 1.7

Any ideas ? I

what does "no use" mean? It does not have a correct format as you want or the array is empty, or ... — invisal
– invisal, Commented Sep 7, 2013 at 10:10

Naresh · Accepted Answer · 2013-09-07 10:50:51Z

1

Thanks to every one finally i got it

<?php
    // 1. Enter Database details
    $dbhost = 'localhost';
    $dbuser = 'root';
    $dbpass = 'password';
    $dbname = 'DB Name';

    $connection = mysql_connect($dbhost,$dbuser,$dbpass);
   // Check connection
    if (!$connection) {
        die("Database connection failed: " . mysql_error());
    }

    $db_select = mysql_select_db($dbname,$connection);

    $result = mysql_query("SELECT parentproduct_id FROM my_entity_data");

    $storeArray = array();

    while ($row = mysql_fetch_array($result)) {
          array_push($storeArray,$row['parentproduct_id']);
    }

    for ($i=0; $i < 10; $i++) { 
        echo $storeArray[i];
    }

    //echo sizeof($storeArray);
    print_r($storeArray); //to see array data
?>

answered Sep 7, 2013 at 10:50

Naresh

733 silver badges13 bronze badges

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

1 Comment

liyakat Over a year ago

your problem was with ($row = mysql_fetch_array($result, MYSQL_ASSOC)) if you want to get column name then only you can go for this.

liyakat · Accepted Answer · 2013-09-07 10:14:02Z

0

you can use

Try mysql_fetch_assoc($result);

Below note from: php.net

 while ($row = mysql_fetch_assoc($result)) {
        foreach ($row as $key => $value) {
            $storeArray[$i][$key] = $value;
            }
        $i++;
        }

for ($i=0; $i < 10; $i++) { 
    echo $storeArray[i];
    }

hope this will sure work for you.

answered Sep 7, 2013 at 10:14

liyakat

11.9k2 gold badges42 silver badges47 bronze badges

3 Comments

Naresh Over a year ago

Thank for the reply... yeah this one also displaying empty array I mean array is empty

liyakat Over a year ago

SELECT parentproduct_id FROM my_entity_data is given any row ? at php my admin

Naresh Over a year ago

yeah i have 4 rows & that is also displaying

A. Zalonis · Accepted Answer · 2013-09-09 15:38:58Z

-1

Try this

<?php
    $result = mysql_query("SELECT parentproduct_id FROM my_entity_data");
    $storeArray = array();
    while ($row = mysql_fetch_array($result)) {
          array_push($storeArray,$row['parentproduct_id']);
    }


print_r($storeArray); //to see array data
?>

edited Sep 9, 2013 at 15:38

answered Sep 7, 2013 at 10:21

A. Zalonis

1,6096 gold badges27 silver badges42 bronze badges

2 Comments

Naresh Over a year ago

like this also its displaying empty array

A. Zalonis Over a year ago

thy this $result = mysql_query("SELECT parentproduct_id FROM my_entity_data",$connection_variable) or die("Error"); while( $row = mysql_fect_array($result) ){}

Collectives™ on Stack Overflow

Get Column All Values in One Array Using php [duplicate]

3 Answers 3

1 Comment

3 Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

3 Comments

2 Comments

Linked

Related