if($_GET['sort_col'] != "" && $_GET['sort_dir'] != "") $sort = "$_GET[sort_col] $_GET[sort_dir]"; else $sort = "name_last,name_first"; $user_sql = "SELECT user_info.user_id, user_info.name_last, user_info.name_first, user_info.company_name FROM ".DB_LOGIN_NAME.".user LEFT JOIN ".DB_LOGIN_NAME.".user_info ON user.user_id = user_info.user_id LEFT JOIN ".DB_LOGIN_NAME.".user_type_map ON user_type_map.user_id = user.user_id WHERE user.user_expires > NOW() AND user_type_map.type_id = 3 ORDER BY ".$sort; // COMS Members Only $user_rs = $db->Query($user_sql); ?>
Printable Directory | |||
Total : =$db->NumRows();?> | |||
Last Name ![]() ![]() |
First Name ![]() ![]() |
Company ![]() ![]() |
|
![]() |
=$user_row['name_last'];?> | =$user_row['name_first'];?> | =$user_row['company_name'];?> |