从会话用户名中选择

Question

I've read all the questions or at least lots of them and what I see is lots of code that for a beginner like me doesn't help a lot...

Probably, you will say that I'm a noob to start making my own webpage with login, register, and all that stuff and I also see people talking about giving up on mysql stuff to avoid sql injection and all of those security details.

All I need to know is a simply a thing about 1 code I'm getting wrong.

$mail = mysql_query("select email from users where username = '".$_SESSION['username']."'");

This is the variavel I have made to get the email of the actual user in the logged in session.

When I put your email is <?php echo"$mail".; ?>, it gives me the next detail:

your email is Resource id #8.

Why am I getting that? I've made the variable in a place with session started but I don't get what I have in that column on the specified user.

Sorry if I shouldn't post that in here, but I really don't see anyone with the same problem. All I see is complex codes and I really don't understand a lot of that.

I'm still a beginner, so if you guys can give me an hand, I will be grateful.

Answer 1

You have to use mysql_fetch_[array|object|assoc] PHP function

$res = mysql_query("select email from users where username = '".$_SESSION['username']."'");
$field = mysql_fetch_assoc($res);
echo $field['email'];