Convert values in a recordset.

[rrhandle8]

I need a function that will loop through a recordset that has 3 fields, change the value of the number in the second column, and return the recordset so I can create a chart with it.

I've tried a number of different options, but there are problems with all the solutions I have tried so I decided not to confuse you by including all the different version of code I have written.

So, if I pass $rs to a function, how should I loop through it so I can return a different value for the second column which is named $rs['High']?

 

[jpadie]

assuming you want to increase the value of High by one each time, here is some code. you can easily change the manipulation as you require

//example
$rs = mysql_query($sql);
$parsedOutput = parseRS($rs);

	function parseRS(&$rs){
		$output = array();
		while ($row = mysql_fetch_assoc($rs)){
			$row['High']++;
			$output[] = $row;
		}
		return $output;
	}

 

[rrhandle8]

Thanks for the reply.

I forgot to mention I am using ODBC. I tried odbc_fetch_assoc, but it appears there is no such thing.

Is there another way to do this?

 

[jpadie]

check the manual. odbc_fetch_array().

if this is not available on your system, just use one of the other odbc_fetch or odbc_result functions