Execute('SELECT * FROM categori ORDER BY name ASC'); if (!$arecordSet) print $conn->ErrorMsg(); else while (!$arecordSet->EOF) { if ($arecordSet->fields['cord'] == 0) { $aval[] = $arecordSet->fields; } else { $nval[] = $arecordSet->fields; } $arecordSet->MoveNext(); } $smarty->assign('categori', $aval); $smarty->assign('subcat', $nval); $smarty->display('aboutus.php'); $smarty->display('footer.php'); $arecordSet->Close(); $conn->Close(); ###################################### ##aboutus.php 4.1.4.## ###################################### ?>