pahelp naman po sa login here is my code
<?php
require("connection.php");
session_start();
session_destroy();
if(isset($_POST['password'])){
$user = mysql_real_escape_string($_POST['username']);
$password = mysql_real_escape_string($_POST['password']);
$SQL='SELECT * FROM user_account WHERE Username = "'.$user.'" AND Password="'.$password.'"';
$result=mysql_query($SQL,$connection);
if (mysql_num_rows($result)!=0){
if($user=="user"){
//echo '<script> alert("hello'.$user.'."); </script>';
session_start();
$_SESSION['login'] = 1;
header("location:vote.php");
}
elseif ($user=="admin") {
//echo '<script> alert("hello'.$user.'."); </script>';
session_start();
$_SESSION['login'] = 1;
header("location
thers.php");
}
}
else {
echo '<script> alert("Wrong user name or password"); </script>';
}
}
?>
dapat po dun sa user hindi mismong "user" na text ang mababasa ung ,, mabasa po dapat ung laman sa sql which is name ng field is Username help po