function GetSelectBoxRecords() { global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry; global $NumDiveSiteFacilitiesRecordsDesired, $DiveSiteFacilitiesId, $DiveSiteFacilitiesRank, $DiveSiteFacilitiesDescription; global $DesiredRecord; global $DiveSiteFacilitiesIdArray, $DiveSiteFacilitiesRankArray, $DiveSiteFacilitiesDescriptionArray; $connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql'); $rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to aquatreasurequest database'); # $sql="select * from DiveSiteFacilities where(DiveSiteFacilitiesId = '".strip_tags(addslashes($DesiredRecord))."') order by DiveSiteFacilitiesId"; $sql = "select DiveSiteFacilitiesId,DiveSiteFacilitiesRank,DiveSiteFacilitiesDescription from DiveSiteFacilities order by DiveSiteFacilitiesRank"; $result = mysql_query($sql, $connection) or die("ERROR!! DiveSiteFacilities Select * failure"); $NumDiveSiteFacilitiesRecordsDesired = mysql_num_rows($result); mysql_close($connection); for ($i = 0; $i < $NumDiveSiteFacilitiesRecordsDesired; $i++) { $rowdata = mysql_fetch_row($result); $DiveSiteFacilitiesIdArray[] = $rowdata[0]; $DiveSiteFacilitiesRankArray[] = $rowdata[1]; $DiveSiteFacilitiesDescriptionArray[] = $rowdata[2]; } PutVariablesIntoSession(); return; }
function InitializeProgram() { global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry; global $NumDiveSiteMedicalRecords, $DiveSiteMedicalId, $DiveSiteMedicalRank, $DiveSiteMedicalDescription; $connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql'); $rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to aquatreasurequest database'); $sql = "select * from DiveSiteMedical order by DiveSiteMedicalRank"; $result = mysql_query($sql, $connection) or die("ERROR!! DiveSiteMedical InitializeProgram failure"); $NumDiveSiteMedicalRecords = mysql_num_rows($result); if ($NumDiveSiteMedicalRecords == 0) { InitializeVariables(); } else { GetLastRecord($connection, $result); } PutVariablesIntoSession(); mysql_close($connection); return; }
function Db_Add() { global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry; global $NumDiveSitePOIRecords, $DiveSitePOIId, $DiveSiteId, $DiveSitePOIEnteredBy, $DiveSitePOIDateEntered; global $DiveSiteCity, $DiveSiteProvince, $DiveSiteCountry, $DiveSiteName, $DiveSiteMajorName; global $DiveSiteMinorName, $DiveSiteExactLat, $DiveSiteExactLong, $DiveSitePOITitle, $DiveSitePOIType; global $DiveSitePOILat, $DiveSitePOILong, $DiveSitePOINoteKeywords, $DiveSitePOINotes, $DiveSitePOIPictureURLFileInfo; $connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql'); $rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to divesites database'); $sql = "insert into DiveSitePOI(DiveSiteId,DiveSitePOIEnteredBy,DiveSitePOIDateEntered,DiveSiteCity,DiveSiteProvince,DiveSiteCountry,DiveSiteName,DiveSiteMajorName,DiveSiteMinorName,DiveSiteExactLat,DiveSiteExactLong,DiveSitePOITitle,DiveSitePOIType,DiveSitePOILat,DiveSitePOILong,DiveSitePOINoteKeywords,DiveSitePOINotes,DiveSitePOIPictureURLFileInfo) values ("; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteId)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSitePOIEnteredBy)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSitePOIDateEntered)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteCity)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteProvince)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteCountry)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteName)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteMajorName)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteMinorName)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteExactLat)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteExactLong)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSitePOITitle)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSitePOIType)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSitePOILat)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSitePOILong)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSitePOINoteKeywords)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSitePOINotes)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSitePOIPictureURLFileInfo)) . "')"; $result = mysql_query($sql, $connection) or die("ERROR!! DiveSitePOI ADD failure"); $DiveSitePOIId = mysql_insert_id($connection); PutVariablesIntoSession(); mysql_close($connection); return; }
function InitializeProgram() { global $db, $user, $serverhost, $password; global $NumDiveSiteRecords, $DiveSiteId, $DiveSiteStatus, $DiveSiteEnteredBy, $DiveSiteDateEntered; global $DiveSiteCity, $DiveSiteProvince, $DiveSiteCountry, $DiveSiteName, $DiveSiteMajorName; global $DiveSiteMinorName, $DiveSiteRating, $DiveSiteType, $DiveSiteLevel, $DiveSiteElevation; global $DiveSiteElevationUnits, $DiveSiteWater, $DiveSiteDifficulty, $DiveSiteTideTable, $DiveSiteTideTableNotes; global $DiveSiteBestDiveMonths, $DiveSiteTimeRestrictions, $DiveSitePermitRequired, $DiveSiteWinterTemp; global $DiveSiteSummerTemp, $DiveSiteFallTemp, $DiveSiteSpringTemp, $DiveSiteDepthMin, $DiveSiteDepthMax; global $DiveSiteDepthUnits, $DiveSiteVisibilityMinimum, $DiveSiteVisibilityMaximum, $DiveSiteVisibilityUnits; global $DiveSiteHazards, $DiveSiteHazardNotes, $DiveSiteBottomComposition, $DiveSiteCompositionNotes; global $DiveSiteTelephoneNotes, $DiveSiteFacilities, $DiveSiteFacilitiesNotes, $DiveSiteMedical; global $DiveSiteMedicalNotes, $DiveSiteRecommendationNotes, $DiveSiteEAPNotes, $DiveSiteNotes; global $DiveSiteExactLat, $DiveSiteExactLong, $DiveSiteShoreLat, $DiveSiteShoreLong, $DiveSiteShoreNotes; global $DiveSiteWebPage, $DiveSiteBackground; $connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql'); $rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to aquatreasurequest database'); $sql = "select * from DiveSite order by DiveSiteStatus"; $result = mysql_query($sql, $connection) or die("ERROR!! DiveSite InitializeProgram failure"); $NumDiveSiteRecords = mysql_num_rows($result); if ($NumDiveSiteRecords == 0) { InitializeVariables(); } else { GetLastRecord($connection, $result); } PutVariablesIntoSession(); mysql_close($connection); return; }
function InitializeProgram() { global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry; global $NumDiveSiteVideoRecords, $DiveSiteVideoId, $DiveSiteId, $DiveSiteVideoDateEntered, $DiveSiteCity; global $DiveSiteProvince, $DiveSiteCountry, $DiveSiteName, $DiveSiteMajorName, $DiveSiteMinorName; global $DiveSiteDifficulty, $DiveSiteExactLat, $DiveSiteExactLong, $DiveSiteVideoTitle, $DiveSiteVideoType; global $DiveSiteVideoNoteKeywords, $DiveSiteVideoURLFileInfo, $DiveSiteVideoNotes; $connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql'); $rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to aquatreasurequest database'); $sql = "select * from DiveSiteVideo order by DiveSiteId"; $result = mysql_query($sql, $connection) or die("ERROR!! DiveSiteVideo InitializeProgram failure"); $NumDiveSiteVideoRecords = mysql_num_rows($result); if ($NumDiveSiteVideoRecords == 0) { InitializeVariables(); } else { GetLastRecord($connection, $result); } PutVariablesIntoSession(); mysql_close($connection); return; }
function InitializeProgram() { global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry; global $NumDiveSiteMarineLifeRecords, $DiveSiteMarineLifeId, $DiveSiteId, $DiveSiteMarineLifeEnteredBy; global $DiveSiteMarineLifeDateEntered, $DiveSiteCity, $DiveSiteProvince, $DiveSiteCountry, $DiveSiteName; global $DiveSiteMajorName, $DiveSiteMinorName, $DiveSiteExactLat, $DiveSiteExactLong, $DiveSiteMarineLifeDomain; global $DiveSiteMarineLifeKingdom, $DiveSiteMarineLifePhylum, $DiveSiteMarineLifeClass, $DiveSiteMarineLifeSubClass; global $DiveSiteMarineLifeInfraClass, $DiveSiteMarineLifeOrder, $DiveSiteMarineLifeFamily; global $DiveSiteMarineLifeGenus, $DiveSiteMarineLifeSpecies, $DiveSiteMarineLifeCommonName; global $DiveSiteMarineLifeScientificName, $DiveSiteMarineLifePictureURLFileInfo1, $DiveSiteMarineLifePictureURLFileInfo2; global $DiveSiteMarineLifePictureURLFileInfo3, $DiveSiteMarineLifePictureURLFileInfo4, $DiveSiteMarineLifePictureURLFileInfo5; global $DiveSiteMarineLifeNotes; $connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql'); $rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to aquatreasurequest database'); $sql = "select * from DiveSiteMarineLife order by DiveSiteId"; $result = mysql_query($sql, $connection) or die("ERROR!! DiveSiteMarineLife InitializeProgram failure"); $NumDiveSiteMarineLifeRecords = mysql_num_rows($result); if ($NumDiveSiteMarineLifeRecords == 0) { InitializeVariables(); } else { GetLastRecord($connection, $result); } PutVariablesIntoSession(); mysql_close($connection); return; }
function Db_Add() { global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry; global $NumDiveSitePixRecords, $DiveSitePixId, $DiveSiteId, $DiveSitePixEnteredBy, $DiveSitePixDateEntered; global $DiveSiteCity, $DiveSiteProvince, $DiveSiteCountry, $DiveSiteName, $DiveSiteMajorName; global $DiveSiteMinorName, $DiveSiteExactLat, $DiveSiteExactLong, $DiveSitePixTitle, $DIveSitePixType; global $DiveSitePixNoteKeywords, $DiveSitePixPictureURLFileInfo, $DiveSitePixNotes; $connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql'); $rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to aquatreasurequest database'); $sql = "insert into DiveSitePix(DiveSiteId,DiveSitePixEnteredBy,DiveSitePixDateEntered,DiveSiteCity,DiveSiteProvince,DiveSiteCountry,DiveSiteName,DiveSiteMajorName,DiveSiteMinorName,DiveSiteExactLat,DiveSiteExactLong,DiveSitePixTitle,DIveSitePixType,DiveSitePixNoteKeywords,DiveSitePixPictureURLFileInfo,DiveSitePixNotes) values ("; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteId)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSitePixEnteredBy)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSitePixDateEntered)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteCity)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteProvince)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteCountry)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteName)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteMajorName)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteMinorName)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteExactLat)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSiteExactLong)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSitePixTitle)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DIveSitePixType)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSitePixNoteKeywords)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSitePixPictureURLFileInfo)) . "',"; $sql = $sql . "'" . strip_tags(addslashes($DiveSitePixNotes)) . "')"; $result = mysql_query($sql, $connection) or die("ERROR!! DiveSitePix ADD failure"); #-------------------- record has been added $DiveSitePixId = mysql_insert_id($connection); mysql_close($connection); #$DiveSitePixId='9999'; # fake id to test #------------ now to move the file with the name properly set --------------------------------- #echo('Pix ID is: '.$DiveSitePixId.'<br>'); #echo('Pix File name: '.$DiveSitePixURLFileInfo.'<br>'); $target_dir = "DiveSiteImages/"; $target_name = $DiveSiteName . '_' . str_pad($DiveSitePixId, 8, '0', STR_PAD_LEFT); #echo('target name is: '.$target_name.'<br>'); $target_file = $target_dir . basename($_FILES["DiveSitePixPictureURLFileInfo"]["name"]); #echo('target file is: '.$target_file.'<br>'); $uploadOk = 1; $imageFileType = pathinfo($target_file, PATHINFO_EXTENSION); // Check if image file is a actual image or fake image if (isset($_POST["submit"])) { $check = getimagesize($_FILES["DiveSitePixPictureURLFileInfo"]["tmp_name"]); if ($check !== false) { # echo "File is an image - " . $check["mime"] . "."; $uploadOk = 1; } else { # echo "File is not an image."; $uploadOk = 0; } } // Check if file already exists if (file_exists($target_file)) { # echo "Sorry, file already exists."; $uploadOk = 0; } // Check file size if ($_FILES["fileToUpload"]["size"] > 10000000) { # echo "Sorry, your file is too large."; $uploadOk = 0; } // Allow certain file formats if ($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg" && $imageFileType != "gif" && $imageFileType != "JPG" && $imageFileType != "PNG" && $imageFileType != "JPEG" && $imageFileType != "GIF") { # echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed."; $uploadOk = 0; } // Check if $uploadOk is set to 0 by an error if ($uploadOk == 0) { echo "Sorry, your file was not uploaded."; exit; // if everything is ok, try to upload file } else { $target_file = $target_dir . $target_name . '.' . $imageFileType; $target_file = preg_replace('/\\s+/', '_', $target_file); if (move_uploaded_file($_FILES["DiveSitePixPictureURLFileInfo"]["tmp_name"], $target_file)) { # echo "The file ". basename( $_FILES["DiveSitePixPictureURLFileInfo"]["name"]). " has been uploaded as ".$target_file; } else { echo "Sorry, there was an error uploading your file."; exit; } } $DiveSitePixPictureURLFileInfo = $target_file; PutVariablesIntoSession(); Db_Update(); return; }
function InitializeProgram() { global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry; global $NumDiveSiteReviewRecords, $DiveSiteReviewId, $DiveSiteId, $DiveSiteReviewReviewerLevel; global $DiveSiteReviewDateEntered, $DiveSiteCity, $DiveSiteProvince, $DiveSiteCountry, $DiveSiteName; global $DiveSiteMajorName, $DiveSiteMinorName, $DiveSiteReviewRating, $DiveSiteReviewTemp, $DiveSiteReviewVisibility; global $DiveSiteReviewNotes, $DiveSiteReviewPix1URLFileInfo, $DiveSiteReviewPix1Note, $DiveSiteReviewPix2URLFileInfo; global $DiveSiteReviewPix2Note, $DiveSiteReviewPix3URLFileInfo, $DiveSiteReviewPix3Note, $DiveSiteReviewPix4URLFileInfo; global $DiveSiteReviewPix4Note, $DiveSiteExactLat, $DiveSiteExactLong; $connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql'); $rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to aquatreasurequest database'); $sql = "select * from DiveSiteReview order by DiveSiteId"; $result = mysql_query($sql, $connection) or die("ERROR!! DiveSiteReview InitializeProgram failure"); $NumDiveSiteReviewRecords = mysql_num_rows($result); if ($NumDiveSiteReviewRecords == 0) { InitializeVariables(); } else { GetLastRecord($connection, $result); } PutVariablesIntoSession(); mysql_close($connection); return; }
function Db_Update() { global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry; global $NumDiveSiteCoursesRecords, $DiveSiteCourse, $DiveSiteId, $DiveSiteCourseEnteredBy, $DiveSiteCourseDateEntered; global $DiveSiteCity, $DiveSiteProvince, $DiveSiteCountry, $DiveSiteName, $DiveSiteMajorName; global $DiveSiteMinorName, $DiveSiteExactLat, $DiveSiteExactLong, $DiveSiteCourseTitle, $DiveSiteCourseNoteKeywords; global $DiveSiteCourseWhyNotes, $DiveSiteCourseURLFileInfo; $connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql'); $rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to divesites database'); $DiveSiteCourse = $_SESSION['DiveSiteCourse']; $sql = "update DiveSiteCourses SET "; $sql = $sql . "DiveSiteId='" . strip_tags(addslashes($DiveSiteId)) . "',"; $sql = $sql . "DiveSiteCourseEnteredBy='" . strip_tags(addslashes($DiveSiteCourseEnteredBy)) . "',"; $sql = $sql . "DiveSiteCourseDateEntered='" . strip_tags(addslashes($DiveSiteCourseDateEntered)) . "',"; $sql = $sql . "DiveSiteCity='" . strip_tags(addslashes($DiveSiteCity)) . "',"; $sql = $sql . "DiveSiteProvince='" . strip_tags(addslashes($DiveSiteProvince)) . "',"; $sql = $sql . "DiveSiteCountry='" . strip_tags(addslashes($DiveSiteCountry)) . "',"; $sql = $sql . "DiveSiteName='" . strip_tags(addslashes($DiveSiteName)) . "',"; $sql = $sql . "DiveSiteMajorName='" . strip_tags(addslashes($DiveSiteMajorName)) . "',"; $sql = $sql . "DiveSiteMinorName='" . strip_tags(addslashes($DiveSiteMinorName)) . "',"; $sql = $sql . "DiveSiteExactLat='" . strip_tags(addslashes($DiveSiteExactLat)) . "',"; $sql = $sql . "DiveSiteExactLong='" . strip_tags(addslashes($DiveSiteExactLong)) . "',"; $sql = $sql . "DiveSiteCourseTitle='" . strip_tags(addslashes($DiveSiteCourseTitle)) . "',"; $sql = $sql . "DiveSiteCourseNoteKeywords='" . strip_tags(addslashes($DiveSiteCourseNoteKeywords)) . "',"; $sql = $sql . "DiveSiteCourseWhyNotes='" . strip_tags(addslashes($DiveSiteCourseWhyNotes)) . "',"; $sql = $sql . "DiveSiteCourseURLFileInfo='" . strip_tags(addslashes($DiveSiteCourseURLFileInfo)) . "' where DiveSiteCourse='" . $DiveSiteCourse . "'"; $result = mysql_query($sql, $connection) or die("ERROR!! DiveSiteCourses DATA failure"); PutVariablesIntoSession(); mysql_close($connection); return; }
function InitializeProgram() { global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry; global $NumDiveSupportRecords, $DiveSupportId, $DiveSupportStatus, $DiveSupportType, $DiveSupportName; global $DiveSupportAddress1, $DiveSupportAddress2, $DiveSupportCity, $DiveSupportProvince, $DiveSupportCountry; global $DiveSupportPhone1, $DiveSupportPhone1Type, $DiveSupportPhone2, $DiveSupportPhone2Type; global $DiveSupportPhone3, $DiveSupportPhone3Type, $DiveSupportWebsite, $DiveSupportEmail, $DiveSupportExactLat; global $DiveSupportExactLong, $DiveSupportHoursMon, $DiveSupportHoursTues, $DiveSupportHoursWed; global $DiveSupportHoursThu, $DiveSupportHoursFri, $DiveSupportHoursSat, $DiveSupportHoursSun; global $DiveSupportServices, $DiveSupportSuppliersNote, $DiveSupportNotes, $DiveSupportPaidDate, $DiveSupportPCZip; $connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql'); $rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to divesites database'); $sql = "select * from DiveSupport order by DiveSupportStatus"; $result = mysql_query($sql, $connection) or die("ERROR!! DiveSupport InitializeProgram failure"); $NumDiveSupportRecords = mysql_num_rows($result); if ($NumDiveSupportRecords == 0) { InitializeVariables(); } else { GetLastRecord($connection, $result); } PutVariablesIntoSession(); mysql_close($connection); return; }
function InitializeProgram() { global $db, $user, $serverhost, $password, $Add, $Edit, $Delete, $Search, $Start, $Expiry; global $NumDiveSiteEAPRecords, $DiveSiteEAPId, $DiveSiteId, $DiveSiteEAPEnteredBy, $DiveSiteEAPDateEntered; global $DiveSiteEAPCity, $DiveSiteEAPProvince, $DiveSiteEAPCountry, $DiveSiteName, $DiveSiteMajorName; global $DiveSiteMinorName, $DiveSiteExactLat, $DiveSiteExactLong, $DiveSiteEAPMedical, $DiveSiteEAPRecompression; global $DiveSiteEAPContact1, $DiveSiteEAPContact2, $DiveSiteEAPTravelNotes; $connection = mysql_connect($serverhost, $user, $password) or die('ERROR!! Cannot connect to MySql'); $rs = mysql_select_db($db, $connection) or die('ERROR!! Cannot connect to aquatreasurequest database'); $sql = "select * from DiveSiteEAP order by DiveSiteId"; $result = mysql_query($sql, $connection) or die("ERROR!! DiveSiteEAP InitializeProgram failure"); $NumDiveSiteEAPRecords = mysql_num_rows($result); if ($NumDiveSiteEAPRecords == 0) { InitializeVariables(); } else { GetLastRecord($connection, $result); } PutVariablesIntoSession(); mysql_close($connection); return; }