Logodiv> Unable to connect to the database server at this time.

'); } // Select the geneology database if (!@mysql_select_db('geneology')){ exit('

Unable to locate the geneology database at this time.

'); } // ---------------------------------------------- // // if data has been submitted, add it to the database // // ---------------------------------------------- if(!($_POST['schoolName']==Null)){ //Need lots of Data Testing Right Here. $schoolName='\'' . $_POST['schoolName'] . '\''; $personKey='\'' . $_POST['personKey'] . '\''; if($_POST['gradDate']==Null){$gradDate = "NULL";}else{$gradDate='\'' . $_POST['gradDate'] . '\'';}; if($_POST['startDate']==Null){$startDate = "NULL";}else{$startDate='\'' . $_POST['startDate'] . '\'';}; if($_POST['degree']==Null){$degree = "NULL";}else{$degree='\'' . $_POST['degree'] . '\'';}; if($_POST['schoolCity']==Null){$schoolCity = "NULL";}else{$schoolCity='\'' . $_POST['schoolCity'] . '\'';}; if($_POST['schoolState']=="NULL"){$schoolState = "NULL";}else{$schoolState='\'' . $_POST['schoolState'] . '\'';}; $dataReadyToAdd = 'INSERT INTO schools set schoolName=' . $schoolName . ', personKey=' . $personKey . ', gradDate=' . $gradDate . ', startDate=' . $startDate . ', degree=' . $degree . ', schoolCity=' . $schoolCity . ', schoolState=' . $schoolState . ';'; echo '

' . ' ' . $schoolName . ' ' . $personKey . ' ' . $gradDate . ' ' . $startDate . ' ' . $degree . ' ' . $degreeCity . ' ' . $degreeState . '

'; if (@mysql_query($dataReadyToAdd)) {echo '

Schooling for ' . $_POST['personKey'] . ' was added to the Database.

';}else{echo'

Error adding schooling for ' . $_POST['personKey'] . ' to the database.

' . mysql_error() . '

';} // ---------------------------------------------- // // End add record to database // // ---------------------------------------------- }else{ // ---------------------------------------------- // // Display the default page, a form to enter data. // // ---------------------------------------------- ?>

Enter the following information for the Schooling / Military.

For multiple schools / military tours, fill this form out for each instance.


Select Person:'; echo '

'; ?>

Date of Entrance: in the form 0000-00-00

Date of Graduation* / Discharge*: in the form 0000-00-00

School* / Service*:

Degree Attained / Ending Rank:

City of Schooling:

State of Schooling:

* Denotes a Required Field

back