Adding to an array from $row

Question

How do I add each result from $row to the $valueIDArray? I then want to use the $valueIDArray to get results from a second database, how do I do that?

$sql = "SELECT * FROM venue
WHERE capacity >= 'partySize'";

//step 2 - executing the query
$result =& $db->query($sql);
if (PEAR::isError($sql)) {
    die($result->getMessage());
}


while($row = $result -> fetchrow()){
    $valueIDArray = $row[0];
}

Marcin Nabiałek · Accepted Answer · 2014-05-13 18:21:14Z

2

You should do it this way:

$valueIDArray = array()

while($row = $result -> fetchrow()){
    $valueIDArray[] = $row[0];
}

Define array before loop, and in loop simple add elements to array using [] after array name

answered May 13, 2014 at 18:21

Marcin Nabiałek

112k43 gold badges271 silver badges299 bronze badges

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

Comments

xate · Accepted Answer · 2014-05-13 18:21:23Z

2

$sql = "SELECT * FROM venue WHERE capacity >= 'partySize'";

//step 2 - executing the query
$result =& $db->query($sql);
if (PEAR::isError($sql)) {
    die($result->getMessage());
}

$valueIDArray = array();
while($row = $result -> fetchrow()){
    $valueIDArray[] = $row[0];
}

You have to add the [] braces. Like this, you always add another entry for the row.

answered May 13, 2014 at 18:21

xate

6,3723 gold badges20 silver badges43 bronze badges

1 Comment

Marcin Nabiałek Over a year ago

I see you added declaring array before loop :)

Collectives™ on Stack Overflow

Adding to an array from $row

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related