add custom to mysql_fetch_assoc results array

Question

is it possible to add custom data to the results so it can be used the same as the $results being returned?

ie i'd like to add a random number to the results;

$recordSet = mysql_query($sql,$this->conn);
$results = array();
while ($row = mysql_fetch_assoc($recordSet)){
    $results[]=$row;
    /// add to results[] a custom field and value, ie 'random' = 1000
}
return $results;

and then i can use it the same as;

foreach($results as $res) $title = $res['title'], $random = $res['random'];

?

n1313 · Accepted Answer · 2010-03-04 09:41:54Z

4

Why not?

while ($row = mysql_fetch_assoc($recordSet)){
    $row['random'] = rand() * 1000;
    $results[] = $row;    
}

answered Mar 4, 2010 at 9:41

n1313

21.6k7 gold badges33 silver badges46 bronze badges

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

2 Comments

v3nt Over a year ago

hey n1313 - that doesn't get returned as part of the $results array. think i need somink like 'add to results array'; array( 'random' => '1000'), just looking again now

Bart van Heukelom Over a year ago

Unless your question is wrong or you're doing something weird, this is the correct answer. What's going astray?

Pavunkumar · Accepted Answer · 2010-03-04 09:43:43Z

0

Add the random values in $result array

 
$row['random'] = $random_val # calculated random values 1000

answered Mar 4, 2010 at 9:43

Pavunkumar

5,36915 gold badges46 silver badges69 bronze badges

2 Comments

v3nt Over a year ago

adding it to the array is where im stuck!

Pavunkumar Over a year ago

You need to add this statement ( $row['random']=$random_val ) in your while loop ,before adding $row in $result Array

Collectives™ on Stack Overflow

add custom to mysql_fetch_assoc results array

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related