get.php
[code]function makeHtmlSelectDBChk($id,$data,$val_field)
{
$make_html = “”;
foreach( $data as $key => $val ){
$key += 1;
$field_name = “”;
for($i = 0; $i < count($id); $i++) {
if( $val[seq] == $id[$i] ) {
$field_name = “$val[$val_field]”;
if ($make_html) $make_html .= ", ";
$make_html .= “$field_name”;
}
}
}
return $make_html;
}
echo ‘’;
$data=getTM_Tasks();
foreach($data as $key =>$value){
//Staff
$srt_staff[position] = 'desc';
$staff_array = getTM_Staff("","",$srt_staff);
$id_staff = explode(",", $value[staff]);
$staff_str = makeHtmlSelectDBChk($id_staff,$staff_array,name);
echo ("<row id='".$value['seq']."'>");
print("<cell><![CDATA[".$value['status']."]]></cell>");
print("<cell><![CDATA[".$staff_str."]]></cell>");
print("</row>");
}
echo ‘’;[/code]
filling the xml using above code. for getting the Staff name using makeHtmlSelectDBChk
when display the grid using this code, it will take 7 seconds to display. becoz of the makeHtmlSelectDBChk function. Even its not complicated also 100 rows only availbale in the db_table …
How to solve this problem? Help me.
Thanks in advance…