Email address into form

Joined: Feb 07, 2006 Posts: 13

I've got a form that I am able to extract the userID from their cookie to set it as a value:

cookiedecode($user);
$username = $cookie[1];

<input type=\"hidden\" name=\"Commissioner\" value=\"$username\">

Is there a way I can do the exact same thing but to look up their E-mail address so I can have this line added?

<input type=\"hidden\" name=\"Email\" value=\"$email\">

Thanks for the input.

Site Admin Joined: Oct 25, 2004 Posts: 756

yeah, use this to get their email....

Code:

cookiedecode($user);
$username = $cookie[1];

$result = $db->sql_query("SELECT user_email FROM ".$user_prefix."_users WHERE username='$username'");
list($user_email) = $db->sql_fetchrow($result);

<input type=\"hidden\" name=\"Commissioner\" value=\"$username\">

<input type=\"hidden\" name=\"Email\" value=\"$user_email\">