<?
// session_start();
// $start_var = 1;
// session_register(start_var);

//print header
$page_name = "client";
require("header.php");
?>

<td valign="top" class="text">
<center><P>
<? 
echo $username . "  " . $password;
if ($username && $password) {
   $db = odbc_connect("DB5338A", "5338", "miff0609");
   $query = "SELECT * FROM qselClientDetails WHERE (Username = '$username') AND (Password = '$password')";
   $rsx = odbc_exec($db,$query);
   
   $client_id = (odbc_result($rsx, "ClientID"));
   if ($client_id > 0)  // IF CLIENT EXISTS
   {
      echo "<P>Login Successful";
   } else {
      echo "<P>Invalid Username and/or Password";
   }
} else {
    // provide form to log in 
    echo "<form method=post action=\"login-ses.php\">";
    echo "<table>";
    echo "<tr><td>Userid:</td>";
    echo "<td><input type=text name=username></td></tr>";
    echo "<tr><td>Password:</td>";
    echo "<td><input type=password name=password></td></tr>";
    echo "<tr><td colspan=2 align=center>";
    echo "<input type=submit value=\"Log in\"></td></tr>";
    echo "</table></form>";
  }
?>

</center>
</td>

<?
$right_nav = array("forgot", "help");
require("footer.php");
?>