for ( $i=0 ; $i < $totalRows_cpn_details ; $i++ ) { print " "; print " "; print ""; print " "; $type_list=$cpn_types['type_id']; $type_id=$type_list[i]; // begin Recordset $type_id__call_type_description = '-1'; if (isset($type_id)) { $type_id__call_type_description = $type_id; } $query_call_type_description = sprintf("select description from type where id=%s", $type_id__call_type_description); $call_type_description = $proso->SelectLimit($query_call_type_description) or die($proso->ErrorMsg()); $totalRows_call_type_description = $call_type_description->RecordCount(); // end Recordset echo $call_type_description->Fields('description');; print ""; print ""; echo $cpn_details->Fields(duration); print ""; print ""; echo $cpn_details->Fields(billed); print ""; $cpn_types=$cpn_details->FetchRow(); print ""; }