[SOLVED] newbie problem: simple login check script ... how do i echo out the found name

[chelnov63]

Hi guys,

 

I know the following is wrong... if a record is found how do i echo out the corresponing name? Thanks in advance

 

<?php
require_once("dbDetails.php");

//THIS FILES CHECKS WHETHER THE USER CAN LOG IN OR NOT
$email = $_POST["email"];
$password = $_POST["password"];
$currentdate = date("Y-m-d");


//mysqldetails


$SQL = "SELECT * FROM members_tbl WHERE email ='".$email."' AND password = '".$password."'";
$rs = mysql_query($SQL,$conn);
$numRows = mysql_num_rows($rs);

if($numRows == 1){

echo $rs["name"]; 

}else{

echo "user not found";

}


?>

[pocobueno1388]

<?php

require_once("dbDetails.php");

//THIS FILES CHECKS WHETHER THE USER CAN LOG IN OR NOT
$email = $_POST["email"];
$password = $_POST["password"];
$currentdate = date("Y-m-d");


//mysqldetails


$SQL = "SELECT * FROM members_tbl WHERE email ='".$email."' AND password = '".$password."'";
$rs = mysql_query($SQL,$conn);
$numRows = mysql_num_rows($rs);
$row = mysql_fetch_assoc($SQL); //Fetch the rows

if($numRows == 1){

echo $row["name"]; 

}else{

echo "user not found";

}

?>

[chelnov63]

Thanks for that poco ... appreciate it