userlogin code work.. but cookie does not set

pinehead18

<?php




    $con = mysql_connect("localhost", "", "") or die(mysql_error());
    $db = mysql_select_db("pinehead", $con) or die(mysql_error());
    $sql = "SELECT * FROM users where uname='$uname' and pass='$pass'";
    $result =  mysql_query($sql);
    $row =  mysql_fetch_array($result);

    if ($row["uname"] == $uname && $row["pass"] ==
$pass) {
        setcookie ("user", $uname, time()+604800);
        echo "logged in";
        } else {
        echo "NOt logged in";
}


if ($_COOKIE['user']) { 
         echo "worked!";
        } else {
        echo "didn't work";
                }

?>

When i perform this script with the right username and pass word it says "logged in" then it says "didn't work" which of course menas that it is not setting.... Or at least reading a cookie.

If you have any suggestion i would much appritiate it.

Thank you for your time.
Anthony

drag0n

hmmm I may be wrong, but I suggest you do something like this to see if user/pass matches:

$sql = "SELECT ID FROM " . $Table . " WHERE Name='" .$name . "' AND Password='" . md5($Password) . "' LIMIT 1"; 
if(!($result = mysql_query($sql))) die(mysql_error()); 
if(mysql_num_rows($result) == 1) {        

setcookie ("user", $uname, time()+604800); 
        echo "logged in"; 

} else 
{ 
        echo "NOt logged in"; 
 }

pinehead18

its the cookie that isn't working.. It logs into sql just fine.. it just isn't setting the cookie for some odd reason.

drag0n

have you set $uname before in the script?

tuf-web_co_uk

try this as your if statement

<?
if ($_COOKIE["user"] != "") {  

         echo "worked! ".$_COOKIE["user"].""; 
        } else { 
        echo "didn't work"; 
                } 
?>

drag0n

or:
if (isset($_COOKIE['user']))
oops I didnt see that