User login script problem

[pt4siek]

ob_start();

include("common.php"); //database & table info

if(!($link_id = mysql_connect($Host, $User, $Pass)))
die(mysql_erorr());

mysql_select_db($D😎;

$sql = "SELECT Name Password FROM " . $Table . " WHERE Name='" . addslashes($POST['Name']) . "' AND Password='" . md5($POST['Password']) . "' LIMIT 1";

$result = mysql_query($sql);
if(!($result = mysql_query($sql))) {

die(mysql_error()); }

if ($data = mysql_fetch_assoc($result))
{
echo ($data['Name']); // why it doesn't display anything ?????????????
}

if (mysql_num_rows($result) == 1)
{

setcookie($POST['Name'], TRUE, time()+(3600 24));
setcookie(md5($POST['Password']), TRUE, time()+(3600 24));
ob_end_flush();

echo "Continue to the <a href=members.php>Members</a> page."; 

}

else
{
echo "Login failure";
}

[JasonL]

$sql = "SELECT Name , Password FROM " . $Table . " WHERE Name='" . addslashes($POST['Name']) . "' AND Password='" . md5($POST['Password']) . "' LIMIT 1";

[90Nz0]

$sql = "SELECT Name Password FROM " . $Table . " WHERE Name='" . addslashes($_POST['Name']) . "' AND Password='" . md5($_POST['Password']) . "' LIMIT 1"; 


$result = mysql_query($sql , $db) or die("no result on<BR>". mysql_error());
if (! $result)
{
echo "$v0tess3ql<BR><BR>ERROR 1<BR><BR>"; 
}

$num_rows = mysql_num_rows($result);
for ($i = 1; $i <= $num_rows; $i++)
{
$display_result = mysql_fetch_array($result);


echo "$display_result[Name]";


  }
  

[JasonL]

No , between name and password?

[90Nz0]

Are you getting a SQL error, or a PHP one?

If it's a SQL one - copy'n'paste it in here.

[pt4siek]

there is no error but that line:
if ($data = mysql_fetch_assoc($result))
{
echo ($data['Name']);
}
doesn't give me any result in hmtl... why?
$result is defined. so why?

[xblue]

if it does not return errors, possibly your query is syntactically correct but returns 0 records.

insert echo $sql; to see what it looks like.