mysql data to email from php

Question

Shown data from mysql query in php file:

while ($row = mysql_fetch_array($sql)){ 
  echo 'ID: '.$row['ID']; 
  echo ' First Name: '.$row['First']; 
  echo ' Last Name: '.$row['Last']; 
  echo ' Phone: '.$row['Phone'];

}

I need to send those results to email
How to do this? like:

$message = 'ID: '.$row['ID'];

not working: I receive message "ID:" without result

Please elaborate on what "not working" means. Are you getting errors? — Mike Brant, Jan 07 '13 at 20:56
@TheCOMPLETEPHPNewbie To surpress warnings (a generally bad idea) — Madbreaks, Jan 07 '13 at 20:56
The `@` symbol prevents errors being output check out [this question](http://stackoverflow.com/questions/1032161/what-is-the-use-of-symbol-in-php). — Tom Walters, Jan 07 '13 at 20:57
I know, but usually it is used in with variable, but in this case, it was unusall to me, but not working.. he means mail is not sending.. i gues — samayo, Jan 07 '13 at 20:58

score 2 · Answer 1 · answered Jan 07 '13 at 20:57

2

You don't have a $to address. Moreover, please remove the @ and don't suppress the errors. Also, check if the $headers are defined.

answered Jan 07 '13 at 20:57

Teena Thomas

5,139
1
13
17

I receive message "ID:" without result – Telu Jan 07 '13 at 22:09
You need to check your query to see if the row has any data in column `ID`. – Teena Thomas Jan 08 '13 at 14:20

score -1 · Answer 2 · answered Jan 07 '13 at 20:57

-1

Take a look at PHPMailer Library. It is used by many php developers, it is very easy to use and is powerful as well.

answered Jan 07 '13 at 20:57

Davit

1,394
5
21
47

1

What's wrong with using `mail`? Nothing. Op needs help determining why his/her attempted use of it is not working. – Madbreaks Jan 07 '13 at 21:00

mysql data to email from php

2 Answers2