PHP email function

[AlGale]

Hi.

I am trying to understand how a piece of code works, in order that I can use it again in the future:

  $email = mysql_result($result, 0, "email");
  $from = "From: [email][e-mail][/email] \r\n";
  $mesg = "The password you registered with us is: $password \r\n"
          ."For extra security, please change it next time you log in. \r\n";
  if (mail($email, "MySite login information", $mesg, $from))

It is actually the first line I need some explanation on - the rest seems self explanatory (I just included it so you could see why the first line was needed).

Why are 3 parameters passed to mysql_result? Obviously, the code is called after successful completeion of a mysql query (obtaining the email address of a user from the database) - so my question is this:

what does the 0, "email" part mean and do?

Thanks.

[Shrike]

You can either specify the offset of the field (you have specified 0 meaning the first field) or the actual name (you use 'email' i.e the column named email) So unless the email column is also the first then you won't get a result.

mysql_result($result, "email");

should return the value of the email field relative to the query used in mysql_query()

[AlGale]

Thanks for the reply. My email field is actually the 3rd in the table - and yet this code works fine. Does that make sense?

[Shrike]

Perhaps the last argument takes precedence 🙂

[AlGale]

Sounds good. Thanks