PHP array with variables inside?

Question

I need help :)

I have a while/loop that gets values from my database. This loop combines database values with $_POST input and generales a $score for each item. CODE:

while($row=mysql_fetch_assoc($res)){ 
    $score=($row["near_beach_score"]*$result_a)+
    ($row["near_city_score"]*result_b)+
    ($row["near_swim_pool_score"]*result_c)+
    ($row["near_public_transport_score"]*result_d)+
    $row["house_promote_score"];

$array_content.='array('.$row["id"].', '.$score.') ';

when the while/loop is done I want to have a multiple array with the content of the string generated in the while/loop.

Like: $complete_array = array ($array_content);

and then i want to apply a array_multisort.

How to concatenate/insert $array_content into $complete_array = array ($array_content); ?

Apreciate if you have time to help. /Sérgio

Ja͢ck · Accepted Answer · 2013-04-08 07:37:59Z

1

Assuming that id is a unique field:

$arr = array();
while ($row = mysql_fetch_assoc($res)) {
    $score = ...;
    $arr[$row['id']] = $score;
}

It stores the value of $row['id'] in the keys and $score in the values.

answered Apr 8, 2013 at 7:37

Ja͢ck

174k39 gold badges269 silver badges316 bronze badges

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

1 Comment

Sergio Over a year ago

Thank you Jack! I did as you suggested and did arsort($arr); to sort my array. Nice.

Le_Morri · Accepted Answer · 2013-04-08 07:33:26Z

1

Try this:

<?php
$array_content = array();
while($row=mysql_fetch_assoc($res)){
    $score=($row["near_beach_score"]*$result_a) + 
            ($row["near_city_score"]*result_b)+ 
            ($row["near_swim_pool_score"]*result_c)+ 
            ($row["near_public_transport_score"]*result_d)+ 
            $row["house_promote_score"];

    $array_content []=array($row["id"], $score);
}

you produced a String. If you remove the ' you will get an array

answered Apr 8, 2013 at 7:33

Le_Morri

1,63914 silver badges18 bronze badges

Collectives™ on Stack Overflow

PHP array with variables inside?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related