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
//error_reporting(E_ALL);
//ini_set("display_errors", 1);

$pagetitle = "Join the YPF";

include_once($_SERVER['DOCUMENT_ROOT'] . "/php/inc_db.php");
include_once($_SERVER['DOCUMENT_ROOT'] . '/cesanet/inc_shared.php');
?>
<img src="https://www.cesa.co.za/sites/default/files/CESA%20YPF_Logo_small.jpg" alt="YPF" hspace="10" />
<?php
$bDisplayForm = true;

if (isset($_POST["act"])) {
    // Check for all fields filled in
    if (
        empty($_POST["Association"]) || empty($_POST["FirstName"]) || empty($_POST["Surname"]) || empty($_POST["TelNum"]) || empty($_POST["DOBYear"])
        || !is_numeric($_POST["DOBYear"])
    ) {
        echo "<p><font color='red'><b>The following fields are all required:<br>
		Your membership association,<br>
		First name and surname,<br>
		Telephone number,<br>
		Year of birth<br>
		Please ensure that all the required information has been filled in, and resubmit the form:</b></font></p>";
        //Check year of birth
    } elseif (date("Y", mktime(0, 0, 0, 0, 0, $_POST["DOBYear"])) <= (date("Y") - 40)) {
        echo "<p><font color='red'><b>You must be 40 years of age or younger to join the Young Professionals Forum</b></font></p>";
    } else {

// Check for an existing, matching contact
        $sMatchMsg = "";
        $arrMatchIDs = array();

// First check on email address
        if (!empty($_POST["Email"])) {
            $sql = "SELECT ContactsID FROM YPFContacts WHERE LOWER(PreferredEmail)='" . strtolower(addslashes($_POST["Email"])) . "'";
            $recContacts = mysql_query($sql);
            while ($rowContacts = mysql_fetch_assoc($recContacts)) {
                $sMatchMsg = "Email address";
                $arrMatchIDs[] = $rowContacts["ContactsID"];
            }
            mysql_free_result($recContacts);
        }

// Then check on name
        if (strlen($sMatchMsg) <= 0) {
            $sql = "SELECT ContactsID FROM YPFContacts WHERE LOWER(ContactFirstName)='" . strtolower(addslashes($_POST["FirstName"])) . "'
			AND LOWER(ContactSurname)='" . strtolower($_POST["Surname"]) . "'";
            $recContacts = mysql_query($sql);
            while ($rowContacts = mysql_fetch_assoc($recContacts)) {
                $sMatchMsg = "First name and Surname";
                $arrMatchIDs[] = $rowContacts["ContactsID"];
            }
            mysql_free_result($recContacts);
        }
        if (empty($sMatchMsg)) {
            $sql = "SELECT ContactsID FROM YPFContacts WHERE LOWER(ContactInitials)='" . strtolower(addslashes($_POST["Initials"])) . "'
			AND LOWER(ContactSurname)='" . strtolower(addslashes($_POST["Surname"])) . "' AND ((ContactFirstName IS NULL) OR (ContactFirstName=''))";
            $recContacts = mysql_query($sql);
            while ($rowContacts = mysql_fetch_assoc($recContacts)) {
                $sMatchMsg = "Initials and Surname";
                $arrMatchIDs[] = $rowContacts["ContactsID"];
            }
            mysql_free_result($recContacts);
        }

// If there was no match to existing data, add this as a new contact
        if (strlen($sMatchMsg) <= 0 || (isset($_REQUEST['selContact']) && $_REQUEST['selContact'] == 'NONE')) {
            $sDOB = "NULL";
            if (!empty($_POST["DOBDay"]) && !empty($_POST["DOBMonth"]) && !empty($_POST["DOBYear"]) && is_numeric($_POST["DOBDay"]) && is_numeric($_POST["DOBYear"]))
                $sDOB = "'" . $_POST["DOBYear"] . "-" . $_POST["DOBMonth"] . "-" . substr("00" . $_POST["DOBDay"], -2) . "'";

$iOfficeHead = 0;
            if (isset($_POST["OfficeHead"]) && ($_POST["OfficeHead"] == "y"))
                $iOfficeHead = 1;
            $iPrincipal = 0;
            if (isset($_POST["Principal"]) && ($_POST["Principal"] == "y"))
                $iPrincipal = 1;

$sql = "INSERT INTO YPFContacts (ContactSurname, ContactInitials, ContactFirstName,
				ContactDesignation, PositionInFirm,
			OfficeHead, Principal, Association)
				VALUES ('" . addslashes($_POST["Surname"]) . "',
			'" . addslashes($_POST["Initials"]) . "', '" . addslashes($_POST["FirstName"]) . "',
			'" . addslashes($_POST["Designation"]) . "', '" . addslashes($_POST["Position"]) . "',
			" . $iOfficeHead . ", " . $iPrincipal . ", '" . addslashes($_POST["Association"]) . "')";
            mysql_query($sql);

// Get new ContactsID
            $query = "SELECT MAX(ContactsID) FROM YPFContacts AS ContactsID";
            $result = mysql_query($query) or die("Scope_Identity Failed");
            $row = mysql_fetch_array($result);
            $NewContactsID = $row[0];

$sql = "UPDATE YPFContacts SET PersonalTel='" . addslashes($_POST["TelNum"]) . "',
			PersonalFax='" . addslashes($_POST["PersonalFax"]) . "', CellPhone='" . addslashes($_POST["CellPhone"]) . "',
			PreferredEmail='" . addslashes($_POST["Email"]) . "', BirthDate=" . addslashes($sDOB) . ",
			ProfessionalRegistrations='" . addslashes($_POST["ProfReg"]) . "',
			Qualifications='" . addslashes($_POST["Qual"]) . "',
			IDNumber='" . addslashes($_POST["IDNumber"]) . "', Comments='" . addslashes($_POST["Expertise"]) . "',
			Association='" . addslashes($_POST["Association"]) . "',
            Province='" . addslashes($_POST["Province"]) . "'
			WHERE ContactsID = " . $NewContactsID;
            mysql_query($sql);

$sql = "INSERT INTO `Contacts` (  `ContactSurname`,  `ContactInitials`, `ContactFirstName`,  `ContactDesignation`,  `Language`,
  `BirthDate`,  `NameOfSpouse`,  `CellPhone`,  `PersonalTel`,  `PersonalFax`,  `Comments`,  `ProfessionalRegistrations`,  `Qualifications`,
  `PreferredEmail`,  `ContactType`,  `PostalAddress`,  `Address2`,  `TownCity`,  `Country`,  `PostalCode`,  `OrgName`,  `IDNumber`
) SELECT   `ContactSurname`,  `ContactInitials`,  `ContactFirstName`,  `ContactDesignation`,  `Language`,  `BirthDate`,  `NameOfSpouse`,  `CellPhone`,
  `PersonalTel`,  `PersonalFax`,  `Comments`,  `ProfessionalRegistrations`,  `Qualifications`,  `PreferredEmail`,  'YPF',  `PostalAddress`,  `Address2`,
   `TownCity`,  `Country`,  `PostalCode`,  Association,  `IDNumber` FROM YPFContacts WHERE ContactsID = " . $NewContactsID;
            mysql_query($sql);
            echo "<p><b>Thank you. We have added your information to our database.</b></p>";

if (!empty($_POST["Email"])) {

$messageText = '<p>Dear YPF Member,</p>'
                    . '<p><b>Welcome on board as a member of the YPF.</b></p>'
                    . '<p>It is with great pleasure that I welcome you to our forum.</p>'
                    . '<p>We are happy that you chose to join CESA and hope that you will continue being a valued participant and contributor of our forum and organization.</p>'
                    . '<p>CESA YPF objectives include:'
                    . '<ul>'
                    . '<li>Promoting of engineering and built environment careers, the consulting engineering Industry and CESA</li>'
                    . '<li>Retention of young professionals within the engineering industry</li>'
                    . '<li>Building capacity and knowledge amongst members of the YPF</li>'
                    . '<li>Sharing Information and networking</li>'
                    . '<li>Aiding professional registration</li>'
                    . '</ul>'
                    . '</p>'
                    . '<p>Benefits of joining YPF/volunteering:'
                    . '<ul>'
                    . '<li>You would be on our newsletter that will keep you informed about the industry.</li>'
                    . '<li>You would be included on issues that affect the industry directly.</li>'
                    . '<li>You will be given opportunities that most won\'t get, such as invites to events and networking with industry leaders.</li>'
                    . '<li>You will contribute to making a difference to people.</li>'
                    . '</ul>'
                    . '</p>'
                    . '<p>Your participation and contribution will be highly valued. Once again, welcome and feel free to share your thoughts with us.</p>'
                    . '<p>Yours faithfully,</p>'
                    . '<p>____________________</p>'
                    . '<p><b>Godfrey Ramalisa</b><br />'
                    . 'Manager: Stakeholder Liaison<br />'
                    . 'Email: <a href="mailto:godfreyr@cesa.co.za">godfreyr@cesa.co.za</a><br />'
                    . 'Webpage: <a href="https://www.cesa.co.za/ypf/">https://www.cesa.co.za/ypf/</a></p>';

maill($_POST["Email"], "Welcome on board as member of the YPF.", $messageText, null, array('from-address' => 'webmaster@cesa.co.za', 'from-name' => 'CESA YPF', 'isHTML' => true));
            }

$bDisplayForm = false;

$mailbody = "<p><b>YPF Contact information submitted on the CESA website:</b><br>
			<table border=1 width=600 cellspacing=0 cellpadding=10>
			<tr><td><b>Association</b></td><td>" . $_POST["Association"] . "</td></tr>
			<tr><td><b>Province</b></td><td>" . $_POST["Province"] . "</td></tr>
			<tr><td><b>Position</b></td><td>" . $_POST["Position"] . "</td></tr>
			<tr><td><b>Designation</b></td><td>" . $_POST["Designation"] . "</td></tr>
			<tr><td><b>Initials</b></td><td>" . $_POST["Initials"] . "</td></tr>
			<tr><td><b>First Name</b></td><td>" . $_POST["FirstName"] . "</td></tr>
			<tr><td><b>Surname</b></td><td>" . $_POST["Surname"] . "</td></tr>
			<tr><td><b>Tel Num</b></td><td>" . $_POST["TelNum"] . "</td></tr>
			<tr><td><b>Cell Num</b></td><td>" . $_POST["CellPhone"] . "</td></tr>
			<tr><td><b>Email Address</b></td><td>" . $_POST["Email"] . "</td></tr>
			<tr><td><b>Birth Date</b></td><td>" . $_POST["DOBDay"] . "/" . $_POST["DOBMonth"] . "/" . $_POST["DOBYear"] . "</td></tr>
			<tr><td><b>Professional Registrations</b></td><td>" . $_POST["ProfReg"] . "</td></tr>
			<tr><td><b>Qualifications</b></td><td>" . $_POST["Qual"] . "</td></tr>
			<tr><td><b>Fields of Expertise</b></td><td>" . $_POST["Expertise"] . "</td></tr>
			</table>
			";

$headers = 'MIME-Version: 1.0' . "\r\n";
            $headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
            $headers .= 'From: webmaster@cesa.co.za' . "\r\n";

mail("godfrey@cesa.co.za", "New YPF Contact", $mailbody, $headers);
        } else {
            // Display the matches
            echo "<p><b>The information you have provided matches one or more existing records in our database, which have the same " . $sMatchMsg . ". If one of the records displayed below is in fact you, please select it so that we know to update the information with the data you have provided.</b></p>";
            $bDisplayForm = false;
?>
            <form action="/ypf/young-professionals-forum/about-the-ypf/join-the-ypf-non-members/" method="post">
                <input type="hidden" name="Association" value="<?php echo $_POST["Association"]; ?>" />
                <input type="hidden" name="FirstName" value="<?php echo stripslashes($_POST["FirstName"]); ?>" />
                <input type="hidden" name="Surname" value="<?php echo stripslashes($_POST["Surname"]); ?>" />
                <input type="hidden" name="Initials" value="<?php echo $_POST["Initials"]; ?>" />
                <input type="hidden" name="Designation" value="<?php echo $_POST["Designation"]; ?>" />
                <input type="hidden" name="TelNum" value="<?php echo $_POST["TelNum"]; ?>" />
                <input type="hidden" name="PersonalFax" value="<?php echo $_POST["PersonalFax"]; ?>" />
                <input type="hidden" name="CellPhone" value="<?php echo $_POST["CellPhone"]; ?>" />
                <input type="hidden" name="Email" value="<?php echo $_POST["Email"]; ?>" />
                <input type="hidden" name="DOBDay" value="<?php echo $_POST["DOBDay"]; ?>" />
                <input type="hidden" name="DOBMonth" value="<?php echo $_POST["DOBMonth"]; ?>" />
                <input type="hidden" name="DOBYear" value="<?php echo $_POST["DOBYear"]; ?>" />
                <input type="hidden" name="IDNumber" value="<?php echo $_POST["IDNumber"]; ?>" />
                <input type="hidden" name="ProfReg" value="<?php echo stripslashes($_POST["ProfReg"]); ?>" />
                <input type="hidden" name="Qual" value="<?php echo stripslashes($_POST["Qual"]); ?>" />
                <input type="hidden" name="Expertise" value="<?php echo stripslashes($_POST["Expertise"]); ?>" />
                <input type="hidden" name="Position" value="<?php echo stripslashes($_POST["Position"]); ?>" />
                <input type="hidden" name="Principal" value="<?php echo $_POST["Principal"]; ?>" />
                <input type="hidden" name="OfficeHead" value="<?php echo $_POST["OfficeHead"]; ?>" />
                <input type="hidden" name="Province" value="<?php echo $_POST["Province"]; ?>" />
                <table border=1 width=600 cellspacing=0 cellpadding=10>
                    <tr>
                        <td>&nbsp;</td>
                        <td><b>Firm</b></td>
                        <td><b>Office</b></td>
                        <td><b>Initials</b></td>
                        <td><b>First Name</b></td>
                        <td><b>Surname</b></td>
                    </tr>
                    <?php
                    $sql = "SELECT Contacts.ContactsID, Contacts.ContactFirstName, Contacts.ContactSurname, Contacts.ContactInitials,
				tblMemberFirms.FirmName, tblMemberFirmOffices.OfficeStatus, tblMemberFirmOffices.Province, tblMemberFirmOffices.GeoLocation
				FROM tblMemberFirms, tblMemberFirmOffices, OfficeContacts, Contacts
				WHERE tblMemberFirms.FirmID = tblMemberFirmOffices.FirmID
				AND tblMemberFirmOffices.OfficeID = OfficeContacts.OfficeID
				AND OfficeContacts.ContactsID = Contacts.ContactsID
				AND Contacts.ContactsID IN (" . implode(",", $arrMatchIDs) . ")";
                    //                    echo $sql . '<br />';
                    $recContacts = mysql_query($sql);
                    while ($rowContacts = mysql_fetch_assoc($recContacts)) {
                    ?>
                        <tr>
                            <td><input type="radio" name="selContact" value="<?php echo $rowContacts["ContactsID"]; ?>" /></td>
                            <td><?php echo $rowContacts["FirmName"]; ?></td>
                            <td><?php echo $rowContacts["OfficeStatus"] . "-" . $rowContacts["Province"] . "-" . $rowContacts["GeoLocation"]; ?></td>
                            <td><?php echo $rowContacts["ContactInitials"]; ?></td>
                            <td><?php echo $rowContacts["ContactFirstName"]; ?></td>
                            <td><?php echo $rowContacts["ContactSurname"]; ?></td>
                        </tr>
                    <?php
                    }
                    mysql_free_result($recContacts);
                    ?>
                    <tr>
                        <td><input type="radio" name="selContact" value="NONE" checked="checked" /></td>
                        <td colspan=5><b>None of the above is a match. Please add me as a new record.</b></td>
                    </tr>
                    <tr>
                        <td colspan=6 align=center><input type="submit" name="act" value="Confirm and Continue" /></td>
                    </tr>
                </table>
            </form>
    <?php
        }
    }
}

if ($bDisplayForm) {
    ?>
    <script type="text/javascript" src="/YPF/ajax.js"></script>
    <script language="javascript">
        var dynamicContent_ajaxObjects = new Array();

function findObj(n, d) { //v4.01
            var p, i, x;
            if (!d)
                d = document;
            if ((p = n.indexOf("?")) > 0 && parent.frames.length) {
                d = parent.frames[n.substring(p + 1)].document;
                n = n.substring(0, p);
            }
            if (!(x = d[n]) && d.all)
                x = d.all[n];
            for (i = 0; !x && i < d.forms.length; i++)
                x = d.forms[i][n];
            for (i = 0; !x && d.layers && i < d.layers.length; i++)
                x = findObj(n, d.layers[i].document);
            if (!x && d.getElementById)
                x = d.getElementById(n);
            return x;
        }

function onlyNumbers(inputString) {

var searchForNumbers = /\D+\_+\W+\s+\S+/

return (searchForNumbers.test(inputString) ? false : true);

}

function GetOffices(iFirmID) {
            var ajaxIndex = dynamicContent_ajaxObjects.length;

dynamicContent_ajaxObjects[ajaxIndex] = new sack();

dynamicContent_ajaxObjects[ajaxIndex].requestFile = '/php/getoffices.php?FirmID=' + iFirmID; // Specifying which file to get
            dynamicContent_ajaxObjects[ajaxIndex].execute = true;
            dynamicContent_ajaxObjects[ajaxIndex].runAJAX(); // Execute AJAX function

}

<form action="/ypf/young-professionals-forum/about-the-ypf/join-the-ypf-non-members/" method="post" name="form1" id="form1" onsubmit="MM_validateForm('FirstName', '', 'R', 'Surname', '', 'R', 'TelNum', '', 'R', 'DOBYear', '', 'RisNum');
                return document.MM_returnValue">
        <table width="682" border="0" cellspacing="0" cellpadding="5">
            <tr>
                <td width="265" align="right" valign="top" nowrap="nowrap">Association you belong to:</td>
                <td width="397" valign="top"><label>
                        <input type="text" name="Association" id="Association" value="<?php echo $_REQUEST["Association"]; ?>" size="40">
                    </label></td>
            </tr>
            <tr>
                <td align="right" valign="top" nowrap="nowrap">Designation:</td>
                <td valign="top"><select name="Designation" id="Designation">
                        <option value="Mr" selected="selected">Mr</option>
                        <option value="Miss">Miss</option>
                        <option value="Mrs">Mrs</option>
                        <option value="Ms">Ms</option>
                        <option value="Dr">Dr</option>
                        <option value="Prof">Prof</option>
                    </select></td>
            </tr>
            <tr>
                <td align="right" valign="top" nowrap="nowrap">First Name:</td>
                <td valign="top"><label>
                        <input name="FirstName" type="text" id="FirstName" size="40" />
                    </label></td>
            </tr>
            <tr>
                <td align="right" valign="top" nowrap="nowrap">Initials:</td>
                <td valign="top"><label>
                        <input name="Initials" type="text" id="Initials" size="40" />
                    </label></td>
            </tr>
            <tr>
                <td align="right" valign="top" nowrap="nowrap">Surname:</td>
                <td valign="top"><label>
                        <input name="Surname" type="text" id="Surname" size="40" />
                    </label></td>
            </tr>
            <tr>
                <td align="right" valign="top" nowrap="nowrap">Telephone Number:</td>
                <td valign="top"><input name="TelNum" type="text" id="TelNum" size="40" /></td>
            </tr>
            <tr>
                <td align="right" valign="top" nowrap="nowrap">Cellphone Number:</td>
                <td valign="top"><input name="CellPhone" type="text" id="CellPhone" size="40" /></td>
            </tr>
            <tr>
                <td align="right" valign="top" nowrap="nowrap">Fax Number:</td>
                <td valign="top"><input name="PersonalFax" type="text" id="PersonalFax" size="40" /></td>
            </tr>
            <tr>
                <td align="right" valign="top" nowrap="nowrap">Email Address:</td>
                <td valign="top"><input name="Email" type="text" id="Email" size="40" /></td>
            </tr>
            <tr>
                <td align="right" valign="top">Date Of Birth:</td>
                <td valign="top"><input name="DOBDay" type="text" id="DOBDay" size="3" required />
                    <select name="DOBMonth" id="DOBMonth" required>
                        <option value="01">January</option>
                        <option value="02">February</option>
                        <option value="03">March</option>
                        <option value="04">April</option>
                        <option value="05">May</option>
                        <option value="06">June</option>
                        <option value="07">July</option>
                        <option value="08">August</option>
                        <option value="09">September</option>
                        <option value="10">October</option>
                        <option value="11">November</option>
                        <option value="12">December</option>
                    </select> <input name="DOBYear" type="text" id="DOBYear" size="10" required />
                </td>
            </tr>
            <tr>
                <td align="right" valign="top">ID Number:</td>
                <td valign="top"><input name="IDNumber" type="text" id="IDNumber" size="40" /></td>
            </tr>
            <tr>
                <td align="right" valign="top">
                    <p>Professional Registration (if any) number and date: <span style="font-size: 10px"><br />
                            (e.g. PrEng, PrTechEng, Quantity Surveyor, Architect, CA(SA) etc; full Membership of Institutions etc)</span></p>
                </td>
                <td valign="top"><input name="ProfReg" type="text" id="ProfReg" size="60" /></td>
            </tr>
            <tr>
                <td align="right" valign="top">
                    <p>Qualifications:</p>
                </td>
                <td valign="top"><input name="Qual" type="text" id="Qual" size="60" /></td>
            </tr>
            <tr>
                <td align="right" valign="top">
                    <p>Field/s of Expertise:</p>
                </td>
                <td valign="top"><input name="Expertise" type="text" id="Expertise" size="60" /></td>
            </tr>
            <tr>
                <td align="right" valign="top">Active position in your company:</td>
                <td valign="top"><label>
                        <input name="Position" type="text" id="Position" size="60" />
                    </label></td>
            </tr>
            <tr>
                <td align="right" valign="top">Province:</td>
                <td valign="top"><label>
                        <select name="Province" required>
                            <option value="Eastern Cape">Eastern Cape</option>
                            <option value="Free State">Free State</option>
                            <option value="Gauteng">Gauteng</option>
                            <option value="KwaZulu-Natal">KwaZulu-Natal</option>
                            <option value="Limpopo">Limpopo</option>
                            <option value="Mpumalanga">Mpumalanga</option>
                            <option value="North West">North West</option>
                            <option value="Northern Cape">Northern Cape</option>
                            <option value="Western Cape">Western Cape</option>

</select>
                    </label></td>
            </tr>
            <tr>
                <td align="right" valign="top">&nbsp;</td>
                <td valign="top">&nbsp;</td>
            </tr>
            <tr>
                <td colspan="2" align="center"><label>
                        <input type="submit" name="act" id="act" value="Submit" />
                    </label></td>
            </tr>
        </table>
    </form>
    <script language="javascript">
        <?php
        if (isset($_POST["Designation"])) {
        ?>
            if (xobj = findObj('Designation')) {
                for (i = 0; i < xobj.options.length; i++) {
                    if (xobj.options[i].value == '<?php echo $_POST["Designation"]; ?>') {
                        xobj.selectedIndex = i;
                    }
                }
            }
        <?php
        }
        if (isset($_POST["FirstName"])) {
        ?>
            if (xobj = findObj('FirstName'))
                xobj.value = '<?php echo $_POST["FirstName"]; ?>';
        <?php
        }
        if (isset($_POST["Initials"])) {
        ?>
            if (xobj = findObj('Initials'))
                xobj.value = '<?php echo $_POST["Initials"]; ?>';
        <?php
        }
        if (isset($_POST["Surname"])) {
        ?>
            if (xobj = findObj('Surname'))
                xobj.value = '<?php echo $_POST["Surname"]; ?>';
        <?php
        }
        if (isset($_POST["TelNum"])) {
        ?>
            if (xobj = findObj('TelNum'))
                xobj.value = '<?php echo $_POST["TelNum"]; ?>';
        <?php
        }
        if (isset($_POST["CellPhone"])) {
        ?>
            if (xobj = findObj('CellPhone'))
                xobj.value = '<?php echo $_POST["CellPhone"]; ?>';
        <?php
        }
        if (isset($_POST["PersonalFax"])) {
        ?>
            if (xobj = findObj('PersonalFax'))
                xobj.value = '<?php echo $_POST["PersonalFax"]; ?>';
        <?php
        }
        if (isset($_POST["Email"])) {
        ?>
            if (xobj = findObj('Email'))
                xobj.value = '<?php echo $_POST["Email"]; ?>';
        <?php
        }
        if (isset($_POST["DOBDay"])) {
        ?>
            if (xobj = findObj('DOBDay'))
                xobj.value = '<?php echo $_POST["DOBDay"]; ?>';
        <?php
        }
        if (isset($_POST["DOBMonth"])) {
        ?>
            if (xobj = findObj('DOBMonth')) {
                for (i = 0; i < xobj.options.length; i++) {
                    if (xobj.options[i].value == '<?php echo $_POST["DOBMonth"]; ?>') {
                        xobj.selectedIndex = i;
                    }
                }
            }
        <?php
        }
        if (isset($_POST["DOBYear"])) {
        ?>
            if (xobj = findObj('DOBYear'))
                xobj.value = '<?php echo $_POST["DOBYear"]; ?>';
        <?php
        }
        ?>
    </script>
<?php
}
?>