Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
_notes	[ DIR ]	drwxr-sr-x	2022-12-20 11:09
_vti_cnf	[ DIR ]	drwxr-sr-x	2022-12-20 11:09
certificate	[ DIR ]	drwxr-sr-x	2023-03-22 11:22
includes	[ DIR ]	drwxr-sr-x	2026-08-24 10:12
mail_interface	[ DIR ]	drwxr-sr-x	2025-06-14 09:47
security	[ DIR ]	drwxr-sr-x	2023-09-17 08:02
temp	[ DIR ]	drwxr-sr-x	2026-04-18 22:25
templates	[ DIR ]	drwxr-sr-x	2026-05-25 12:12
tests	[ DIR ]	drwxr-sr-x	2025-07-07 15:54
CaptchaSecurityImages.php	2.26 KB	-rw-r--r--	2022-12-20 11:09
Inc_calendarnew.php	8.59 KB	-rw-r--r--	2017-11-20 10:34
accredcourses.php	7.04 KB	-rw-r--r--	2023-08-22 10:55
adecquestionnaire.php	26.54 KB	-rw-r--r--	2025-08-01 10:38
advisory.php	7.21 KB	-rw-r--r--	2022-12-20 11:09
advisory_full.php	1.31 KB	-rw-r--r--	2022-12-20 11:09
annualdeclaration.php	15.28 KB	-rw-r--r--	2026-01-22 10:25
awardsentry.php	14.55 KB	-rw-r--r--	2025-08-01 10:38
awardsentry.php.bak	11.22 KB	-rw-r--r--	2016-04-13 12:45
bookdetail.php	954 B	-rw-r--r--	2022-12-20 11:09
books.php	4.4 KB	-rw-r--r--	2023-05-16 13:08
branchdocuments.php	1.14 KB	-rw-r--r--	2022-12-20 11:09
branches.php	2.82 KB	-rw-r--r--	2025-08-06 12:54
calendarpdf.php	1.75 KB	-rw-r--r--	2025-08-26 16:52
cceregister.php	55.59 KB	-rw-r--r--	2026-08-14 12:05
ccmregister.php	71.57 KB	-rw-r--r--	2022-12-20 11:09
class.phpmailer.php	44.39 KB	-rw-r--r--	2022-12-20 11:09
class.smtp.php	32.74 KB	-rw-r--r--	2022-12-20 11:09
committeedocs.php	932 B	-rw-r--r--	2022-12-20 11:09
committees.php	2.69 KB	-rw-r--r--	2025-08-06 12:58
cpdapply.php	5.73 KB	-rw-r--r--	2022-12-20 11:09
cpdapplyform.php	34.06 KB	-rw-r--r--	2025-08-01 10:38
cpdproviderapply.php	42.09 KB	-rw-r--r--	2026-02-10 10:10
cpdproviderportal.php	79.47 KB	-rw-r--r--	2025-09-08 07:23
cpdspverify.php	4.27 KB	-rw-r--r--	2025-10-10 10:45
cpdtmverify.php	4.45 KB	-rw-r--r--	2023-06-19 13:44
declineeventreg.php	3.73 KB	-rw-r--r--	2022-12-20 11:09
directorybooking.php	7.39 KB	-rw-r--r--	2022-12-20 11:09
downloadPN.php	385 B	-rw-r--r--	2025-06-26 13:02
downloadfile.php	280 B	-rw-r--r--	2025-08-01 10:38
enews.php	1.33 KB	-rw-r--r--	2022-12-20 11:09
enewsarchive.php	1.09 KB	-rw-r--r--	2022-12-20 11:09
event.php	12.39 KB	-rw-r--r--	2026-08-19 12:22
event_allvenues.php	18.93 KB	-rw-r--r--	2026-08-09 11:44
eventdecline_awards.php	11.79 KB	-rw-r--r--	2022-12-20 11:09
eventregister.php	26.85 KB	-rw-r--r--	2026-02-10 07:56
eventregister_awards.php	19.4 KB	-rw-r--r--	2025-06-20 06:38
eventregister_golf.php	28.83 KB	-rw-r--r--	2025-08-19 08:12
eventtables.php	24.13 KB	-rw-r--r--	2023-06-01 09:51
eventtables.php.bak	3.49 KB	-rw-r--r--	2022-12-20 11:09
fidicgama2018.php	1012 B	-rw-r--r--	2022-12-20 11:09
forum.php	3.25 KB	-rw-r--r--	2022-12-20 11:09
getoffices.php	799 B	-rw-r--r--	2022-12-20 11:09
hrforumsubscribe.php	2.62 KB	-rw-r--r--	2022-12-20 11:09
hrforumunsubscribe.php	1.32 KB	-rw-r--r--	2022-12-20 11:09
inc_calendarnew.php	10.56 KB	-rw-r--r--	2025-08-21 10:11
inc_captcha.php	337 B	-rw-r--r--	2022-12-20 11:09
inc_db.php	12.33 KB	-rw-r--r--	2025-06-18 12:05
inc_php7.php	6 KB	-rw-r--r--	2025-07-07 12:51
inc_practicenoteslist.php	4.1 KB	-rw-r--r--	2024-07-03 13:52
inc_scecalendar.php	8.55 KB	-rw-r--r--	2025-06-13 08:57
inc_scecalendar_backup.php	6.66 KB	-rw-r--r--	2022-12-20 11:09
inc_scecalendarnew.php	7.84 KB	-rw-r--r--	2026-05-09 09:39
jobshadowschools.php	7.26 KB	-rw-r--r--	2025-06-20 06:38
logout.php	593 B	-rw-r--r--	2025-02-25 08:19
marketingevent.php	122.75 KB	-rw-r--r--	2026-08-03 13:40
marketingeventdecline.php	15.21 KB	-rw-r--r--	2022-12-20 11:09
marketingsurvey.php	5.95 KB	-rw-r--r--	2022-12-20 11:09
matrixtemplate.htm	2.13 KB	-rw-r--r--	2022-12-20 11:09
member_portal_becs.php	2.14 KB	-rw-r--r--	2025-09-12 07:50
member_portal_transformation.php	10.45 KB	-rw-r--r--	2026-05-20 10:07
member_portal_transformation_proxy.php	538 B	-rw-r--r--	2026-05-20 09:08
memberauth.php	991 B	-rw-r--r--	2025-02-25 08:19
memberportal.php	11.79 KB	-rw-r--r--	2026-05-20 09:54
membersearch.php	22.72 KB	-rw-r--r--	2025-02-27 08:02
membersearch_smme.php	6.2 KB	-rw-r--r--	2024-11-27 11:41
memberverify.php	5.25 KB	-rw-r--r--	2022-12-20 11:09
mentors.php	21.68 KB	-rw-r--r--	2025-06-20 06:38
migratenode.php	1.26 KB	-rw-r--r--	2022-12-20 11:09
monofont.ttf	40.07 KB	-rw-r--r--	2022-12-20 11:09
nlc.php	855 B	-rw-r--r--	2022-12-20 11:09
nlcreports.php	2.51 KB	-rw-r--r--	2022-12-20 11:09
php_errors.log	1.06 KB	-rw-r--r--	2026-08-20 23:37
practicenotes.php	4.63 KB	-rw-r--r--	2022-12-20 11:09
practicenotes_full.php	1.33 KB	-rw-r--r--	2022-12-20 11:09
practicenotes_help.php	2.17 KB	-rw-r--r--	2022-12-20 11:09
practicenotes_list.php	2.03 KB	-rw-r--r--	2024-07-03 13:52
practicenotes_search.php	9.43 KB	-rw-r--r--	2022-12-20 11:09
querynlcmatrix.php	15 KB	-rw-r--r--	2022-12-20 11:09
querynlcmatrix.php4	15.38 KB	-rw-r--r--	2012-03-05 08:01
register.php	58.18 KB	-rw-r--r--	2026-05-26 14:55
relay.php	20.33 KB	-rw-r--r--	2025-06-20 06:38
relayteams.php	12.53 KB	-rw-r--r--	2022-12-20 11:09
resendcpdform.php	7.28 KB	-rw-r--r--	2025-08-01 10:38
retiredeng.php	13.45 KB	-rw-r--r--	2025-06-20 06:38
retiredeng_members.php	1.81 KB	-rw-r--r--	2022-12-20 11:09
sanitize.php	10 B	-rw-r--r--	2022-12-20 11:09
sce_survey2015.php	25.85 KB	-rw-r--r--	2022-12-20 11:09
sceallevents.php	8.13 KB	-rw-r--r--	2026-01-20 08:45
scecalendar.php	4.86 KB	-rw-r--r--	2025-06-18 11:18
scecalendar_backup.php	3.17 KB	-rw-r--r--	2025-06-18 11:18
scecalendarnew.php	5.98 KB	-rw-r--r--	2025-08-28 11:14
scecalendarnewtest.php	5.7 KB	-rw-r--r--	2022-03-04 12:37
scecalendartest.php	3.57 KB	-rw-r--r--	2022-03-04 12:38
scecategories.php	914 B	-rw-r--r--	2022-12-20 11:09
scecourses.php	7.18 KB	-rw-r--r--	2026-08-19 12:15
scelist.php	7.72 KB	-rw-r--r--	2025-08-29 07:18
scesubscribe.php	2.06 KB	-rw-r--r--	2022-12-20 11:09
sceupdate.php	1.67 KB	-rw-r--r--	2025-06-18 11:18
scevenuehire.php	6.15 KB	-rw-r--r--	2026-01-23 13:12
sendeventreg.php	19.5 KB	-rw-r--r--	2026-08-14 12:05
sendeventreg2.php	2.83 KB	-rw-r--r--	2026-07-17 14:57
sendeventreg_golf.php	20.23 KB	-rw-r--r--	2026-08-14 12:05
sendeventreg_golf.php.bak	11.69 KB	-rw-r--r--	2016-09-07 09:48
sendreg.php	35.15 KB	-rw-r--r--	2026-08-14 12:05
smsunsub.php	1.89 KB	-rw-r--r--	2025-06-18 11:18
template.php	54.36 KB	-rw-r--r--	2022-12-20 11:09
tenders.php	1.34 KB	-rw-r--r--	2022-12-20 11:09
trainerportal.php	50.27 KB	-rw-r--r--	2025-08-01 11:06
trainerportal.php.bak	2.57 KB	-rw-r--r--	2022-12-20 11:09
unempgrad_members.php	2.38 KB	-rw-r--r--	2025-06-18 11:18
unemployed.php	14.13 KB	-rw-r--r--	2025-06-20 06:38
unemployedreg.php	23.38 KB	-rw-r--r--	2025-06-20 06:38
unempreg_members.php	2.36 KB	-rw-r--r--	2025-06-18 11:18
ypfbranchcommittee.php	1.63 KB	-rw-r--r--	2022-12-20 11:09
ypfcommittees.php	1.57 KB	-rw-r--r--	2022-12-20 11:09
ypfjoin.php	30.29 KB	-rw-r--r--	2025-07-07 15:53
ypfjoin2.php	28.13 KB	-rw-r--r--	2025-06-18 11:18
ypfjoinmatches.php	9.46 KB	-rw-r--r--	2025-06-18 11:18
ypfmentees.php	20.81 KB	-rw-r--r--	2026-08-24 11:52
ypfmentees_members.php	2.42 KB	-rw-r--r--	2025-06-18 11:18

Rename

<?php
session_start();
include( 'inc_db.php' );
// If the form is submitted process here
//$graylight ="#EAEAEA";
extract($_REQUEST);

$recSkills = mysqli_query($conni, "SELECT COUNT(*) AS Num FROM FirmSkillsList");
$rowSkills = mysqli_fetch_assoc($recSkills);
$iMaxSkills = $rowSkills["Num"];
mysqli_free_result($recSkills);

if ($officeid) {

$sql = "SELECT tblMemberFirmOffices.FirmID,
		tblMemberFirmOffices.OfficeStatus,
		tblMemberFirmOffices.OfficeName,
		tblMemberFirmOffices.Address2,
		tblMemberFirmOffices.PostalAddress,
		tblMemberFirmOffices.GeoLocation,
		tblMemberFirmOffices.TownCity,
		tblMemberFirmOffices.PostalCode,
		tblMemberFirmOffices.Country,
		tblMemberFirmOffices.BldgName,
		tblMemberFirmOffices.StreetName,
		tblMemberFirmOffices.Suburb,
		tblMemberFirmOffices.Telephone,
		tblMemberFirmOffices.Fax,
		tblMemberFirmOffices.Email,
		tblMemberFirmOffices.FullOrPartTime,
		tblMemberFirmOffices.OtherStaff,
		tblMemberFirmOffices.ProfessionalStaff,
		tblMemberFirmOffices.NonProfTechStaff,
		tblMemberFirms.URL,
		tblMemberFirms.QMSISOComply,
		tblMemberFirms.QMSISOCert,
		tblMemberFirms.BBBEE
		FROM tblMemberFirmOffices, tblMemberFirms WHERE (tblMemberFirmOffices.OfficeID = '$officeid')
		AND (tblMemberFirmOffices.FullOrPartTime = 'Full Time') AND (tblMemberFirmOffices.FirmID = tblMemberFirms.FirmID)";
    
    // echo 'Please ignore debug info: ' . $sql;

$result = mysqli_query($conni, $sql) or die('An error has occured. Please go back and select another option.');
    $result_rows = mysqli_num_rows($result);
    if ($result_rows > 0) {
        if ($row = mysqli_fetch_array($result)) {
            $pagetitle = $pagetitle . $row["OfficeName"];
            echo "<h1>Member Firm Details</h1>";
            ?>
            
            <?php
            echo "<p>";
            echo "<h4>" . $row["OfficeName"] . "</h4>";
            echo "<p>";
            echo "<table width=\"600\" border=\"0\" cellpadding=\"5\" cellspacing=\"1\">";
            echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Company</td><td valign=\"top\">" . $row["OfficeName"] . "</td></tr>";
            echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Office</td><td valign=\"top\">" . $row["OfficeStatus"] . "</td></tr>";
            echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Physical Address</td><td valign=\"top\">";
            if ($row["BldgName"] != '') {
                echo $row["BldgName"] . "<br>";
            }
            echo $row["StreetName"] . "<br>" . $row["Suburb"] . "</td></tr>";
            echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Postal Address</td><td valign=\"top\">";
            if ($row["Address2"] != '') {
                echo $row["Address2"] . "<br>";
            }
            echo $row["PostalAddress"] . "<br>" . $row["TownCity"] . "<br>" . $row["GeoLocation"] . "<br>" . $row["PostalCode"] . "<br>" . $row["Country"] . "</td></tr>";
            echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Geographic Location</td><td valign=\"top\">" . $row["GeoLocation"] . "</td></tr>";
            echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Telephone</td><td valign=\"top\">" . $row["Telephone"] . "</td></tr>";
            echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Email</td><td valign=\"top\">" . generate_obfuscated_mailto($row["Email"]) . "</td></tr>";
            if ($row["URL"]) {
                if (eregi("http://", $row["URL"])) {
                    echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Website</td><td valign=\"top\"><a href=\"" . $row["URL"] . "\" target=\"new\">" . $row["URL"] . "</a></td></tr>";
                } else {
                    echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Website</td><td valign=\"top\"><a href=\"http://" . $row["URL"] . "\" target=\"new\">" . $row["URL"] . "</a></td></tr>";
                }
            } else {
                echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Website</td><td valign=\"top\">None</td></tr>";
            }
            //echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Full or Part Time</td><td valign=\"top\">".$row["FullOrPartTime"]."</td></tr>";
            $total = $row["ProfessionalStaff"] + $row["NonProfTechStaff"] + $row["OtherStaff"];
            echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Total Staff</td><td valign=\"top\">" . $total . "</td></tr>";
            if (!empty($row["BBBEE"])) {
                echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">BBBEE Level</td><td valign=\"top\">" . $row["BBBEE"] . "</td></tr>";
            }
            echo "<tr><td valign=\"top\" bgcolor=\"$graylight\">Skills & Specialisations</td><td valign=\"top\">";
            $sql = "SELECT SkillName FROM FirmSkillsList JOIN tblMemberFirmSkills USING (SkillsListID) WHERE FirmID=" . $row["FirmID"] . " ORDER BY SkillPriority, SkillName";
            $recSkills = mysqli_query($conni, $sql);
            while ($rowSkills = mysqli_fetch_assoc($recSkills))
                echo $rowSkills["SkillName"] . "<br>";

if (strtolower($row["QMSISOComply"]) == "y") {
                echo "<br>Has implemented a Quality Management System<br>";
            }
            if (strtolower($row["QMSISOCert"]) == "y") {
                echo "<br>(ISO Certified QMS)<br>";
            }

echo "</td></tr>";
            echo "</table>";
            echo "</p>";
        } //end if
    } //end if
    else {
        echo "No details found";
    }
} else {
    switch ($action) {
        case 1 :
            
            // Removed the Full Time office filter
            // AND tblMemberFirmOffices.FullOrPartTime = 'Full Time'

$sql = "SELECT DISTINCT tblMemberFirms.FirmID, tblMemberFirms.DeclarationReceived, tblMemberFirms.FirmName
			FROM tblMemberFirms, tblMemberFirmOffices 
            WHERE tblMemberFirms.FirmID = tblMemberFirmOffices.FirmID  
                AND tblMemberFirms.MemberStatus='Member' 
                AND DeclarationReceived > '2005-01-01 00:00'";
            
            switch ($country) {
                case 'any' :
                    break;
                case 'outside' :
                    $sql .= " AND tblMemberFirmOffices.Country != 'South Africa'";
                    break;
                default :
                    $sql .= " AND tblMemberFirmOffices.Country = '$country'";
                    break;
            } //end switch
            switch ($province) {
                case 'any' :
                    break;
                default :
                    $sql .= " AND tblMemberFirmOffices.Province = '$province'";
                    break;
            } //end switch
            if (!empty($towncity)) {
                $sql .= " AND (tblMemberFirmOffices.TownCity LIKE '%$towncity%' OR tblMemberFirmOffices.GeoLocation LIKE '%$towncity%')";
            }
            if ($containing) {
                $sql .= " AND tblMemberFirms.FirmName LIKE '%$containing%'";
            }

if (isset($_REQUEST["Skills"]) && is_array($_REQUEST["Skills"]) && count($_REQUEST["Skills"]) > 0 && count($_REQUEST["Skills"]) < $iMaxSkills) {
                $sql .= " AND EXISTS (SELECT * FROM tblMemberFirmSkills WHERE tblMemberFirmSkills.FirmID=tblMemberFirms.FirmID AND tblMemberFirmSkills.SkillsListID IN (" . implode(",", $_REQUEST["Skills"]) . "))";
            }

if ($QMS == "1")
                $sql .= " AND tblMemberFirms.QMSISOComply IN ('Y','y')";
            if ($ISO == "1")
                $sql .= " AND tblMemberFirms.QMSISOCert IN ('Y','y')";

switch ($SMME) {
                case '' :
                    break;
                default :
                    if ($SMME == "QSE_EME") {
                        $sql .= " AND (tblMemberFirms.SMME LIKE 'QSE%' OR tblMemberFirms.SMME LIKE 'EME%')";
                    } else {
                        $sql .= " AND tblMemberFirms.SMME LIKE '" . $SMME . "%'";
                    }
                    break;
            } //end switch

switch ($BlackOwned) {
                case '' :
                    break;
                default :
                    $sql .= " AND tblMemberFirms.BlackOwned = '$BlackOwned'";
                    break;
            } //end switch

switch ($BlackWomenOwned) {
                case '' :
                    break;
                default :
                    $sql .= " AND tblMemberFirms.BlackWomenOwned = '$BlackWomenOwned'";
                    break;
            } //end switch

$sql .= " ORDER BY RAND()";

echo "";
            $result = mysqli_query($conni, $sql);
            $result_rows = mysqli_num_rows($result);

echo "<h1>Matching Member Firms:</h1>";

if ($result_rows > 0) {

echo "<p class=\"footer\">The following results match your search criteria.<br>Please note: The order of the displayed results have been randomised to provide equal opportunity for our members.</p><p class=\"footer\">Click on a company name for further information</p>";
                if (($_REQUEST["from"] == "smme") && !empty($_REQUEST["SMME"])) {
                    echo "<p class=\"footer\">CESA member firms may download an Excel spreadsheet of the returned results. You are required to login as a member to do so.<br><b>";
                    if (isset($_SESSION["CID"]) && !empty($_SESSION['CID'])) {
                        $sQS = "SMME=" . filter_var($_REQUEST["SMME"], FILTER_SANITIZE_STRING);
                        $sQS .= "&BlackOwned=" . urlencode(filter_var($_REQUEST["BlackOwned"], FILTER_SANITIZE_STRING));
                        $sQS .= "&BlackWomenOwned=" . urlencode(filter_var($_REQUEST["BlackWomenOwned"], FILTER_SANITIZE_STRING));
                        $sQS .= "&country=" . urlencode(filter_var($_REQUEST["country"], FILTER_SANITIZE_STRING));
                        $sQS .= "&province=" . urlencode(filter_var($_REQUEST["province"], FILTER_SANITIZE_STRING));
                        $sQS .= "&towncity=" . urlencode(filter_var($_REQUEST["towncity"], FILTER_SANITIZE_STRING));
                        $sQS .= "&containing=" . urlencode(filter_var($_REQUEST["containing"], FILTER_SANITIZE_STRING));
                        $sQS .= "&QMS=" . urlencode(filter_var($_REQUEST["QMS"], FILTER_SANITIZE_STRING));
                        $sQS .= "&ISO=" . urlencode(filter_var($_REQUEST["ISO"], FILTER_SANITIZE_STRING));
                        echo "<a href='/downloadsmme.php?" . $sQS . "' target='_blank'><u>Click here to download a spreadsheet now</u></a>";
                    } else {
                        echo "<a href='/login/'>Login Now</a>";
                    }
                    echo "</b></p>";
                }

echo "<table width=\"600\" border=\"0\" cellpadding=\"5\" cellspacing=\"0\"><tr><th>Member</th><th>Geographic Region</th></tr>";

while ($row = mysqli_fetch_array($result)) {
                    $sql = "SELECT tblMemberFirmOffices.OfficeID, tblMemberFirmOffices.GeoLocation
					FROM tblMemberFirmOffices WHERE FirmID=" . $row["FirmID"];
                    switch ($country) {
                        case 'any' :
                            break;
                        case 'outside' :
                            $sql .= " AND tblMemberFirmOffices.Country != 'South Africa'";
                            break;
                        default :
                            $sql .= " AND tblMemberFirmOffices.Country = '$country'";
                            break;
                    } //end switch
                    switch ($province) {
                        case 'any' :
                            break;
                        default :
                            $sql .= " AND tblMemberFirmOffices.Province = '$province'";
                            break;
                    } //end switch
                    if (!empty($towncity)) {
                        $sql .= " AND (tblMemberFirmOffices.TownCity LIKE '%$towncity%' OR tblMemberFirmOffices.GeoLocation LIKE '%$towncity%')";
                    }
                    $sql .= " ORDER BY GeoLocation";
                    $rec2 = mysqli_query($conni, $sql);
                    while ($row2 = mysqli_fetch_assoc($rec2)) {
                        echo "<tr><td><a href=\"" . strtok($_SERVER['REQUEST_URI'], '?') . "?officeid=" . $row2["OfficeID"] . "\">" . $row["FirmName"] . "</a></td>
						<td>" . $row2["GeoLocation"] . "</td></tr>";
                    }
                    mysqli_free_result($rec2);
                }

echo "</table>";
            } else {

echo "<p><b>Sorry, there were no matches for your search criteria.</b><br> Please <a href=\"" . strtok($_SERVER['REQUEST_URI'], '?') . "\">go back</a> and try more general search options.</p>";
            }
            // Free Database Memory
            mysqli_free_result($result);
            break;
        default :
            ?>
            <h1>Welcome to the Consulting Engineers South Africa (CESA) Online Directory</h1>
            <form method="get" action="<?php echo strtok($_SERVER['REQUEST_URI'], '?'); ?>" enctype="multipart/form-data">
                <p><b>Search for a member</b></p>
                <p>Country:
                    <select name="country">
                        <option value="any" selected>Any Country</option>
                        <option value="South Africa">South Africa</option>
                        <option value="outside">Outside of South Africa</option>
                        <?php
                        /* 			$sql = "select distinct Country from tblMemberFirmOffices order by Country";
                          $result = mysql_query($sql);
                          while ($row=mysql_fetch_array($result)) {
                          echo "<option value=\"".$row["Country"]."\">".$row["Country"];
                          }
                         */
                        ?>
                    </select>

Province:
                    <select name="province">
                        <option value="any" selected>Any
                            <?php
                            $sql = "select distinct TRIM(Province) AS Province from tblMemberFirmOffices WHERE Province != '' order by Province";
                            $result = mysqli_query($conni, $sql);
                            while ($row = mysqli_fetch_array($result)) {
                                echo "<option value=\"" . $row["Province"] . "\">" . $row["Province"];
                            }
                            ?>
                    </select>

City/town:
                    <input name="towncity" type="text" placeholder="Leave blank for all">
                </p>
                <p>
                    <b>With a name containing the words </b><input name="containing" type="text" placeholder="Leave blank for all" size="40">
                </p>
                <p>
                    <b>and having the following specialisations or skills</b>:
                    <input type="button" onclick="javascript: jQuery('.skill').prop('checked', false);" value="Select none">
                    <input type="button" onclick="javascript: jQuery('.skill').prop('checked', true);" value="Select all">

<table width="600" border="0" cellpadding="2">
                    <tr><td valign="top" nowrap="nowrap">
                            <?php
                            $sql = "SELECT * FROM FirmSkillsList "
//                                    . "WHERE SkillPriority=1 "
                                    . "ORDER BY SkillName";
                            $recSkills = mysqli_query($conni, $sql);
                            $iNumS = 0;
                            while ($rowSkills = mysqli_fetch_assoc($recSkills)) {
                                ?>
                                <input type="checkbox" class="skill" name="Skills[]" value="<?php echo $rowSkills["SkillsListID"]; ?>" checked id="skill<?php echo $rowSkills["SkillsListID"]; ?>"><?php echo $rowSkills["SkillName"]; ?><br>
                                <?php
                                $iNumS++;
                                if ($iNumS >= 40) {
                                    $iNumS = 0;
                                    ?>
                                </td><td valign="top" nowrap="nowrap">
                                    <?php
                                }
                            }
                            ?>
                        </td></tr></table>
                <p>
                    <input type="checkbox" name="QMS" value="1" id="QMS" />
                    Has implemented a
                    Quality Management System
                    <br>
                    <input type="checkbox" name="ISO" value="1" id="ISO" />
                    QMS is ISO Certified
                    <br>
                </p>
                <p><b>Turnover:</b><br>
                <table width="600" border="0" cellpadding="2">
                    <tr><td valign="top" nowrap="nowrap">
                            <input name="SMME" type="radio" id="SMME_any" value="" checked="checked" />
                            Any / all<br>
                            <input type="radio" name="SMME" value="EME" id="SMME_small" />
                            EME &lt; R6 million<br>
                            <input type="radio" name="SMME" value="QSE" id="SMME_medium" />
                            QSE &gt;= R6 million and &lt; R25 million<br>
                        </td>
                        <td valign="top" nowrap="nowrap">
                            <input type="radio" name="SMME" value="GEN1" id="SMME_large" />
                            GEN 1 &gt;= R25 million and &lt; R35 million<br>
                            <input type="radio" name="SMME" value="GEN2" id="SMME_large2" />
                            GEN 2 &gt;= R35 million and &lt; R50 million<br>
                            <input type="radio" name="SMME" value="GEN3" id="SMME_large3" />
                            GEN 3 &gt;= R50 million and &lt; R60 million<br>
                            <input type="radio" name="SMME" value="GEN4" id="SMME_large4" />
                            GEN 4 &gt;= R60 million and &lt; R70 million<br>
                        </td>
                        <td valign="top" nowrap="nowrap">
                            <input type="radio" name="SMME" value="GEN5" id="SMME_large5" />
                            GEN 5 &gt;= R70 million and &lt; R80 million<br>
                            <input type="radio" name="SMME" value="GEN6" id="SMME_large6" />
                            GEN 6 &gt;= R80 million and &lt; R90 million<br>
                            <input type="radio" name="SMME" value="GEN7" id="SMME_large7" />
                            GEN 7 &gt;= R90 million and &lt; R100 million<br>
                            <input type="radio" name="SMME" value="GEN8" id="SMME_large8" />
                            GEN 8 &gt;= R100 million<br>
                        </td>
                    </tr>
                    <tr>
                        <td colspan="2" valign="top" nowrap="nowrap">
                            <strong>Black Ownership:</strong><br>
                            <input name="BlackOwned" type="radio" id="BlackOwned" value="" checked="true" />
                            Any / all<br>
                            <input type="radio" name="BlackOwned" value="Equal to or greater than 25 and less than 51%" id="BlackOwned4" />
                            Equal to or greater than 25 and less than 51%<br>
                            <input type="radio" name="BlackOwned" value="100%" id="BlackOwned5" />
                            100% Black Owned</td>
                        <td colspan="2" valign="top" nowrap="nowrap">
                            <br>
                            <input name="BlackOwned" type="radio" id="BlackOwned" value="Less than 10%" />
                            Less than 10%<br>
                            <input type="radio" name="BlackOwned" value="Equal to or greater than 51 and less than 100%" id="BlackOwned3" />
                            Equal to or greater than 51 and less than 100%</td>
                    </tr>
                    <tr>
                        <td colspan="2" valign="top" nowrap="nowrap"><strong>Black Women
                                Ownership:</strong><br>
                            <input name="BlackWomenOwned" type="radio" id="BlackOwned6" checked="true" value="" />
                            Any / all<br>
                            <input type="radio" name="BlackWomenOwned" value="Less than 10%" id="BlackOwned9" />
                            Less than 10%<br>
                            <input type="radio" name="BlackWomenOwned" value="Equal to or greater than 10 and less than 30%" id="BlackOwned9" />
                            Equal to or greater than 10 and less than 30%<br>
                            <input type="radio" name="BlackWomenOwned" value="100%" id="BlackOwned8" />
                            100% Black Women Owned</td>
                        <td colspan="2" valign="top" nowrap="nowrap">
                            <br>
                            <input type="radio" name="BlackWomenOwned" value="Equal to or greater than 30 and less than 51%" id="BlackOwned7" />
                            Equal to or greater than 30 and less than 51%
                            <br>
                            <input type="radio" name="BlackWomenOwned" value="Equal to or greater than 51 and less than 100%" id="BlackOwned7" />
                            Equal to or greater than 51 and less than 100%</td>
                    </tr>
                </table>
                <input type="hidden" name="action" value="1">
                <input type="submit" name="search" value="search for a member firm"> <input type="reset" name="reset" value="clear the form">
            </form>
            <p></p>
            <?php
            break;
    } //end case
}//end if else
?>