ODBC not fetching records with PHP

[romax72]

I am getting the following error when I try to call MSSQL queries using php 4.2.2 through ODBC.

Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of odbc_fetch_into(). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in c:\apache group\htdocs\rfptool\db_odbc.inc on line 76

I am getting no data from my queries and this is the only error. I have no connection errors.

Thanks for any help.

[matto]

should be easy:

bool odbc_fetch_into ( resource result_id [, int rownumber, array result_array])

I suppose you are using a "&" before the result_array parameter. remove it and the function should work fine.

(&$variable = pass per reference; $variable = pass per value)

[romax72]

I am not exactly sure what you mean in your post. Here is my code around it. Can you explain with this? Thanks.

function next_record() {
$this->Record = array();
$stat = odbc_fetch_into($this->Query_ID, ++$this->Row, &$this->Record);
if (!$stat) {
if ($this->Auto_Free) {
odbc_free_result($this->Query_ID);
$this->Query_ID = 0;
};
} else {
// add to Record[<key>]
$count = odbc_num_fields($this->Query_ID);
for ($i=1; $i<=$count; $i++)
$this->Record[strtolower(odbc_field_name ($this->Query_ID, $i)) ] = $this->Record[ $i - 1 ];
}
return $stat;
}