[gayashan1]

There is something wrong in this scrict. this doest echo the error mas " NO such a login detail exists" pls help me to find why is that ? (if query exist it shows results )

<?php
session_start();


if(!isset($_SESSION['SESS_LOGIN']) || $_SESSION['SESS_TYPE'] !='admin')// if session variable "login" does not exist.
{


header("location:searchuser.php"); // Re-direct to login-form.php

}
else
{
include("config.php");

$login = mysql_real_escape_string($_POST['login']);
$type = mysql_real_escape_string($_POST['type']);


$sql_select_login =mysql_query("SELECT * FROM members WHERE login = '$login'") or die(mysql_error()); //select by login

///////////////////// SELECT (VIEW) ////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////////////////////////////////////


//$count_login = mysql_num_rows($sql_select_login);
$count_login = mysql_query("SELECT COUNT(login) FROM members WHERE login='$login'") or die(mysql_error());

if($count_login > 0)
{
while($row_select_login = mysql_fetch_array($sql_select_login)) {
$login_selected = $row_select_login["login"];
$password_selected = $row_select_login["password"];
$type_selected = $row_select_login["type"];

echo "$password_selected";
echo "$login_selected";
echo "$type_selected"; }

//echo "<font color=red> Duplicate Entry. Please Verify login</font>";
}
else
{
echo "<font color=red> NO such a login detail exists</font>";

}

mysql_close();

//include("searchuser.php");

}

?>

[alxkls]

the problem is that mysql_query() executes the query but it alone does not return what you are looking for. so even if the query itself returns 1 or more, $count login itself does not equal 1. so let's go to the next line:

Code:

if($count_login > 0)

this is where it all fails. you need the function mysql_num_rows(). or in other words replace the existing condition with

Code:

if(mysql_num_rows($count_login)>0)

and that is of course your logic is correct. what i prefer myself is to store the query in a variable outside the functions and echo out the variable and test the query alone.


on a side note-mysql_close()-there is no point in using it. get rid of it.