Append Column to Query Results

[travis77]

Hello,

 

I'm trying to add a column to the results of a query.

 

So, I get the records

$r = $db->query($sql) or error ('Critical Error', mysql_error ());

 

Now I want to add an extra column and populate that column to the $r recordset. Is this possible?

[per1os]

Where is the $sql located, it would have to be placed in that section...To get the extra column you would need to mysql_fetch_assoc($result); mysql_fetch_array($result);

 

Unless that $db->query() function does that for you, that definiation might help out also.

 

[travis77]

So are you saying that the query should have the extra field in it -

 

$sql = "Select field1, field2, 0 from tblTest"

 

where 0 is the extra field?

 

Then I would have to use fetch_array to fetch each row and add what I need to that extra field?

[per1os]

Yep, to use the fetcharray it goes like

 

while ($row = mysql_fetch_array($r)) {
    print $row['field1'];  // processing here.
}

 

 

[travis77]

Ok, so after I use fetch_array and put the value in that I want

 

while ($row = mysql_fetch_array($r)) {

    $row['field1'] = $i;  // processing here.

    $i++;

}

 

Is there a way to put that back into $r?

[per1os]

Not without an updating statement. via SQL.