Append all values of a SQL result into an array

Question

I want to create an array based on the results of my SELECT query.

The below code works somewhat -- it only adds the last row to the array. I tried declaring the array beforehand and then using array_push but that function doesn't allow me to assign a key, just a value.

    $sql = "SELECT setKey,setValue FROM tblsettings WHERE setApp = '".$data->app."' AND setIP = '".gethostbyname(trim(gethostname()))."'";
    $result = mysql_query($sql);
    if(!$result) die(mysql_error());

    if(mysql_num_rows($result) == 0){
        echo "null";
        exit;
    }

    while($datAssArr = mysql_fetch_assoc($result)){
        $datArr = array($datAssArr["setKey"] => $datAssArr["setValue"]);
    }

    print_r($datArr);

Don't use mysql_* it's deprecated. Use mysqli or pdo.

Horse SMith
– Horse SMith

2013-10-28 00:53:18 +00:00
Commented Oct 28, 2013 at 0:53 — Horse SMith
– Horse SMith, Commented Oct 28, 2013 at 0:53

SeanWM · Accepted Answer · 2013-10-28 00:56:47Z

1

Instead of:

$datArr = array($datAssArr["setKey"] => $datAssArr["setValue"]);

Try:

$datArr[] = array($datAssArr["setKey"] => $datAssArr["setValue"]);
// ----^

Also, don't use the mysql_* functions. They're deprecated. Try PDO instead.

answered Oct 28, 2013 at 0:56

SeanWM

17.1k10 gold badges54 silver badges85 bronze badges

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

2 Comments

Sucrose Over a year ago

Thank you, with your help I ended up using $datArr[$datAssArr["setKey"]] = $datAssArr["setValue"];

Sucrose Over a year ago

I've switched to PDO since this discussion, but am having issues... see new question here: http://stackoverflow.com/questions/19627423/inserting-multiple-rows-with-a-single-query-using-pdo

Collectives™ on Stack Overflow

Append all values of a SQL result into an array

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related