<?php

$DBhost = "localhost";
$DBName = "ets";
$table = "compines";
$name = trim($_POST['usernamex']);
$username1 = @$HTTP_POST_VARS["loginid"];
$password1 = @$HTTP_POST_VARS["password"];
$user= "ets";
$password= "ets";

@MYSQL_CONNECT($DBhost, $user, $password) or die ( "wrong1");
@MYSQL_SELECT_DB($DBName) or die ( "wrong2");

$sqlquery = "SELECT * FROM $table where User_ID ='$username1' AND password='$password1' " ;
$result = mysql_query($sqlquery);
$number = mysql_numrows($result);

$i = 0;

if ($number < 1) 
{ 

echo "\n  Wrong User ID ";
 
}
else
{   
while ($number > $i) 
              {
                    $username = mysql_result($result,$i,"User_ID");
                    $Co_ID  = mysql_result($result,$i,"Co_ID");
                    $Office_ID   = mysql_result($result,$i,"Office_ID");
                    $i++;
               }


setcookie("etsCo_ID", $Co_ID  , time()+604800);
setcookie("etsLog_ID", $username , time()+604800);
setcookie("etsOffice_ID", $Office_ID   , time()+604800);

header("Location: http://www.google.com"); 

} 

?>