<?php
            $db_host = "mysql5";
            $db_user = "abritton";
            $db_pwd = "database";
            $db = "abritton";
            $table = "Staff_Login";

            if (!mysql_connect($db_host, $db_user, $db_pwd))
                die("Can't connect to database");

            if (!mysql_select_db($db))
                die("Can't select database");


mysql_select_db("abritton", $con);
$staffid=mysql_real_escape_string($_POST['staffid']);
$sname=mysql_real_escape_string($_POST['sname']);
$pword=mysql_real_escape_string($_POST['pword']);



                $sql="SELECT * FROM Staff_Login WHERE Staff_ID ='$staffid' AND Password = 'pword';";
if (!mysql_query($sql)) {
header( 'Location: flightdetails.html' );
exit;
}else{

mysql_close($con);
 header( 'Location: flightedit.html' ) ;
 exit;}

?>