while(list()=db_fetch_row());

Anon

I am getting null values. Does anyone know what I might be doing wronge. Thanks for any help.
while(list($fac_cd,$fac_desc)=db_fetch_row $facilityData)){ print("<option value='$fac_cd'>$fac_desc");
}

trooper

dr
You need to show us the SQL statement that preceeds this.

Anon

Sorry about that. Here is all the code. It goes through the loop x number of time, but it does assign a value to variables. ifx_query returns enumerated array, I don’t know if that is the problem, but I have seen an example where it works. Any help or reason why this is not working would be greatly appreciated.

#Here is my Database abstract layer
function db_query($query){
global $dbconnect;
$result=ifx_query($query, $dbconnect);
if (!$result) {
echo "<tt>$query</tt> ";
echo "Query error: <tt>", ifx_error(), ": ", ifx_errormsg(), "</tt> ";
}
return $result;
}

#Here is my SQL
$select ="SELECT events_fac.fac_cd, facility.fac_sdesc ";
$from ="FROM events_fac, facility ";
$where ="WHERE events_fac.fac_cd=facility.fac_cd ";
$order ="ORDER BY facility.fac_sdesc ASC ";
$built_query=$select.$from.$where.$order;
$facility_data=db_query("$built_query");

#Here is where I am trying to process the return
while(list($fac_cd, $fac_sdesc)=ifx_fetch_row($facility_data)){
print("<option value='$fac_cd'>$fac_sdesc</option>");
}

Anon

Got it. It was because of the enumerated array (So I think). I used a generic function to replace ifx_featch_row to return an associative array... here it is... hopefully it will help someone...

function db_fetch_row($query_return) {
$new_array = @ifx_fetch_row($query_return);
$row = array();
if (is_array($new_array))
foreach($new_array as $key=>$val)
$row[] = $val;
return $row;
}