table = "contents"; $node->select = "*"; $node->where = "where content_type = 'Home'"; $row_sel = $mysql->select_assoc($node); ?>

IIMA Activities

table = "activities"; $node->select = "*"; $node->where = "where 1 group by year ORDER BY year DESC"; $resactivities = $mysql->select($node); $totalactivities=$mysql->total($node); ?>
    fetch_assoc($resactivities)) { ?>

    table = "activities"; $node->select = "*"; $node->where = "where year='".$rowactivities['year']."' ORDER BY displaylevel ASC"; $resactivitiesr = $mysql->select($node); while($rowactivitiesr=$mysql->fetch_assoc($resactivitiesr)) { $node=new sqlNode(); $node->table="countries"; $node->select="*"; $node->where="where id='".$rowactivitiesr['country']."'"; $rowcountry=$mysql->select_assoc($node); ?>
    .
    .
    ()
table="users"; $node->select="*"; $node->where="where 1 and active='1' and userstatus='show' ORDER BY iimanumber DESC"; $rowm=$mysql->select_assoc($node); $totalmember= $totaluser=$mysql->total($node); ?>
table="users"; $node->select="*"; $node->where="where active='1' and userstatus='show' ORDER BY iimanumber DESC LIMIT 20"; //echo $mysql->selectSql($node); $resuser=$mysql->select($node); $i=1; while($rowuser=$mysql->fetch_assoc($resuser)) { $node=new sqlNode(); $node->table="countries"; $node->select="*"; $node->where="where id='".$rowuser['country']."'"; $rowcountry=$mysql->select_assoc($node); $node=new sqlNode(); $node->table="specialty"; $node->select="*"; $node->where="where id='".$rowuser['specialty']."'"; $rowspeciality=$mysql->select_assoc($node); ?>
Total number of IIMA :

IIMA Number

Name
Country Resident
Specialty