# Mysql issue

**URL:** <https://forum.kirupa.com/t/mysql-issue/302366>\
**Category:** Uncategorized\
**Created:** [December 28, 2009, 9:31pm UTC](https://forum.kirupa.com/t/mysql-issue/302366 "2009-12-28T21:31:51Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mrkhoros](https://avatars.discourse-cdn.com/v4/letter/m/848f3c/32.png) [@mrkhoros](https://forum.kirupa.com/u/mrkhoros)\
**Post date:** [December 28, 2009, 9:31pm UTC](https://forum.kirupa.com/t/mysql-issue/302366/1 "2009-12-28T21:31:51Z")

</div>

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"); 
 }; 

```

};

?\>

================