Sql Probs

mwood_2k2

Hi guys,

Wish you all a merry xmas !!

Just a quickie here, I am attempting to pull off some data from a database, but I am unsure how to set the variable with the contents of the field in my db, its a login script, I am attempting to pull off the email of a user where their name and password = to whatever they put in the login form... theres a bitta psuedo-code for ya, anyways heres the real code ...


$sql = "SELECT Email FROM " . $Table . " WHERE Name='" . addslashes($_POST['Name']) . "' AND Password='" . md5($_POST['Password']) . "' LIMIT 1"; 
if(!($result = mysql_query($sql))) die(mysql_error()); 

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

setcookie("LoggedIn", TRUE, time()+(3600 * 24)); 

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

} else { 

echo "Login failure"; 
}

At the moment the email variable is undefined when I try it through my browser, hence why I need to set it but am unsure exactly how, can anyone provide me with an example based on the above code?

Cheers in advance!

philipolson

See: http://www.php.net/mysql_fetch_assoc as it contains a full example. Come back if you have a question.

mwood_2k2

Ok, I don't get it lol, how do I set those as variables, I assume that if I do


$Email = "$row["Email"];";

That it would just print out the text, how do I do this?

Cheers in advance

diego25

Pseudocode:

if (mysql_num_rows == 1) {
$row = mysql_fetch_assoc
$Email = $row['Email']
print "$Email continue to..."
} else {
print "fail"
}

Diego

mwood_2k2

Ok thanx diego,

I figured it out ... however I have another question ...

In the future I am going to work with more variables, and so I will need all of them (however many I decide) to be condensed into a variable in my login page, the code for this is below ...


$row = mysql_fetch_assoc($result);

$Name = $row['Name'];
$Email = $row['Email'];

   setcookie("LoggedIn", TRUE, time()+(3600 * 24));
   echo "Welcome $Name ($Email) ... <br><br> Click <a href='forum.php'>here</a> to proceed.";

I would like those two variables and any further ones I specify to be placed within that 'LoggedIn' cookie to be re-used throughout my message board, and so that leads me onto my questions ...

How do I set multiple variables into a single cookie
How do I read the individual variables from said cookie

Cheers in advance