hi. i wrote this with using php but i get unusual result as mysql quary. when i use phpmyadmin it gives me the correct result but it php it gives me : Resource id #3
i dont know what to do . please correct me :2c::2c:
==============
<?php
session_start();
$yes = “<a href=‘logout.php’>logout</a>”;
$no = “<a href=‘index.php’>Countinue</a>”;
$host=“localhost”;
$username=“root”;
$password="";
$db_name=“log”;
$tbl_name=“users”;
if($_SERVER[‘REQUEST_METHOD’] == “POST”) {
$opendb = mysql_connect("$host", “$username”, “$password”)or die(“cannot connect”);
mysql_select_db("$db_name")or die(“cannot select DB”);
$username = mysql_real_escape_string($_POST[‘u’]);
$password = mysql_real_escape_string($_POST[‘p’]);
$l = mysql_query(“SELECT * FROM users WHERE username=’$username’ AND
password=md5(’$password’)”);
echo $_SESSION[‘logged’];
echo $l;
if(mysql_query($l) != true){
$_SESSION['logged']= 0;
echo '<form action=“login.php” method=“post”><input type=“hidden” name=“ac” value=“log”> ';
echo ‘Username: <input type=“text” name=“u” /><br />’;
echo ‘Password: <input type=“password” name=“p” /><br />’;
echo ‘<input type=“submit” value=“Login” />’;
echo ‘</form>’;
}
else {
$_SESSION[‘logged’]= 1;
echo $_SESSION[‘logged’];
echo ‘<br>’;
echo “You are logged in.”;
echo ‘<br>’;
echo $yes;
echo ‘<br>’;
echo $no;
}
};
function check_logged(){
if ($_SESSION['logged'] != 1){
header("Location: login.php");
};
};
?>
================
