I really need help before tomorrow or at least by tomorrow night. I have been working on this for days and still can't get it to run properly. I really need assistance. Here is the question that I need to answer:

Create a Web page that stores airline surveys in a MySQL database. Include fields for the date and time of the flight, flight number, and other fields you consider appropriate for identifying a particular flight. Also, include groups of radio buttons that allow the user to rate the airline on the following criteria:

Friendliness of customer staff

Space for luggage storage

Comfort of seating

Cleanliness of aircraft

Noise level of aircraft

Here is what I have so far:

Survey.html

Please enter the following details

Name

Age

Flight Number

Flight Date

Flight Time

Friendliness of customer staff

No Opinion
Poor
Fair
Good
Excellent

Space for luggage storage

No Opinion
Poor
Fair
Good
Excellent

Comfort of seating

No Opinion
Poor
Fair
Good
Excellent

Cleanliness of aircraft

No Opinion
Poor
Fair
Good
Excellent

Noise level of aircraft

No Opinion
Poor
Fair
Good
Excellent

Show Past Survey Results

submitsurvey.php

You must enter the date, flight number and departure time! Click your browser's Back button to return to the form."; else{ $DBConnect = @mysql_connect("localhost", "root", "AidanCT11"); if($DBConnect === FALSE) echo "

Unable to connect to the database server.

" . "

Error code ".mysql_errno() . ": ".mysql_error()."

"; else { $DBName = "airlineSurvey"; if(!@mysql_select_db($DBName, $DBConnect)){ $SQLstring = "CREATE DATABASE $DBName"; $QueryResult = @mysql_querry($SQLstring, $DBConnect); if($QueryResult === FALSE) echo "

Unable to execute the query.

" . "

Error code ".mysql_errno($DBConnect) . ": ".mysql_error($DBConnect) ."

"; else echo "

You are the first visitor!

"; } mysql_select_db($DBName, $DBConnect); $TableName = "airlineSurvey"; $SQLstring = "SHOW TABLES LIKE '$TableName'"; $QueryResult = @mysql_query($SQLstring, $DBConnect); if(mysql_num_rows($QueryResult) == 0){ $SQLstring = "CREATE TABLE $TableName (countID SMALLINT NOT NULL AUTO_INCREMENT PRIMARY KEY, last_name VARCHAR(40), first_name VARCHAR(40))"; $QueryResult = @mysql_query($SQLstring, $DBConnect); if($QueryResult === FALSE) echo "

Unable to create the table.

" . "

Error code ".mysql_errno($DBConnect) . ": ".mysql_error($DBConnect) ."

"; } $Date=stripslashes($_GET["date"]); $FlightNumber=($_GET["flight"]); $DepartureTime=($_GET["time"]); $Friendliness=($_GET["friendliness"]); $Cleanliness=($_GET["cleanliness"]); $Space=($_GET["space"]); $Noise=($_GET["noise"]); $Comfort=($_GET["comfort"]); $QueryResult = @mysql_query($SQLstring, $DBConnect); if($QueryResult === FALSE) echo "

Unable to execute the query.

" . "

Error code ".mysql_errno($DBConnect) . ": ".mysql_error($DBConnect) ."

"; else echo "

Thank you for completing our survey!

"; } mysql_close($DBConnect); } ?>

ShowPastResults.php

Unable to connect to the database server." . "

Error code ".mysql_errno() . ": ". mysql_error()."

"; else { $DBName = "airlineSurvey"; if (!@mysqli_select_db($DBConnect, $DBName)) die("

There are no past surveys!

"); }} $TableName = "t_survey"; $SQLstring = "SELECT * FROM $TableName"; $QueryResult = @mysqli_query($DBConnect, $SQLstring); if (mysql_num_rows($QueryResult) == 0) echo"

There are no passengers!

"; else{ echo "

The following passengers have completed the survey:

"; echo "

"; echo ""; $Row = mysqli_fetch_assoc($QueryResult); do { echo ""; $Row = mysqli_fetch_assoc($QueryResult); } while ($Row);

$TableName = "t_options"; $SQLstring = "SELECT * FROM $TableName"; $QueryResult = @mysqli_query($DBConnect, $SQLstring); if (mysqli_num_rows($QueryResult) == 0) echo"

There are no survey results!

";

echo "

Survey Results:

"; echo "

Passenger Name

{$Row['psngr_name']}

"; echo ""; $Row = mysqli_fetch_assoc($QueryResult); do { echo ""; echo ""; echo ""; echo ""; echo ""; $Row = mysqli_fetch_assoc($QueryResult); } while ($Row);

mysql_free_result($QueryResult); mysql_close($DBConnect); ?>

Now to provide a visual here is what occurs:

Of course the main page comes up fine and I can click on the radio buttons along with adding the information at the top. But every time I click the submit button here is what I receive regardless what I place in the text boxes:

Thats problem 1. The second problem is when I go back and click on the link to show past results this is what I receive:

The reset button works perfectly fine, but I could really use some assistance in fixing this prior to Monday. Any and all help is greatly appreciated.

xAi ie Survey 09/Projecty Survey.htm 1 Please enter the following details Name Age Flight Nunb Flight Date Flizht Time Friendlinessocsomer staff No Option Pace Gpod Fxcellent Space foc luggage storage No Opinicu OPact Fair Good Excele Comfoet af weating No Opinic Fani Good No Opinicn Poc O lype hene to search

Friendliness of customer staff	Space for luggage storage	Comfort of seating	Cleanliness of aircraft	Noise level of aircraft
{$Row['no_op']}	{$Row['poor']}	{$Row['fair']}	{$Row['good']}	{$Row['exc']}