setQuery("SELECT * FROM #__users WHERE id=" . (int)$_GET['details']); $rows = $database->loadObjectList(); $query = "SELECT * FROM #__country"; $database->setQuery( $query ); $result = $database->query(); $rows_c = $database->loadObjectList(); for ($i=0, $n=count( $rows_c ); $i < $n; $i++) { $row = &$rows_c[$i]; $country[$row->id] = $row->name; } $memtype_array = array(); $members_types = array(); $members_types["1"] = "FULL FOUNDER"; $members_types["2"] = "ASSOCIATE"; $members_types["3"] = "AFFILIATE";; $members_types["4"] = "FULL FOUNDER"; $members_types["5"] = "ASSOCIATE FOUNDER"; $rows["0"]->member_reference; $rows["0"]->contact_title; $rows["0"]->contact_fax; $rows["0"]->contact_gsm; $rows["0"]->contact_function; $rows["0"]->services; $rows["0"]->contact_gsm; $rows["0"]->products; $rows["0"]->case_studies; $rows["0"]->classification; $rows["0"]->applications; $rows["0"]->industry_services; $rows["0"]->solutions; require_once (JPATH_COMPONENT.DS.'views'.DS . 'userprofile' . DS . 'tmpl' . DS.'default.php'); ?>