How do I get SQL select results emailed

Anon

Hi, I am trying to get the results of an SQL SELECT query, executed in a PHP file, emailed to me. I know how to do the email part but how do I get the select results into a variable that can be used in the email. If there was only ever one result I know how to do it but if there are multiple results I am stuck. So far I have the following, appreciate any help.

Query

$sql = "SELECT * FROM enhance WHERE time BETWEEN 1 AND $time";
$result = mysql_query("$sql",$db);

What goes in here?

Email

$to = "myemailaddress";
$subject = "whatever ...";
$message = "$selectresults";
$header = "From: whoever\n";
mail($to, $subject, $message, $header);

jcornett

Add this to your existing code:

Query

$sql = "SELECT * FROM enhance WHERE time BETWEEN 1 AND $time";
$result = mysql_query("$sql",$db);

What goes in here?

While($row = @mysql_fetch_array($result)) {
While(List($key, $val)=each($row)) {
$selectresults .= "$key: $val\n";
}
$selectresults .= "\n\n";
}

This is a pretty generic example, but it will populate the $selectresults variable for you to use in your mail function call.

John Cornett

Anon

Thanks! Got it to work, but curious why it outputs everything twice. For example if one SQL record is found and it has three fields, the $selectresults variable outputs ...

0: value-of-first-field
field-name-1: value-of-first-field
1: value-of-second-field
field-name-2: value-of-second-field
2: value-of-third-field
field-name-3: value-of-third-field

Is there a way to supress the lines that begin with numbers? Thanks again!

jcornett

Try adding this to your code to skip the numeric indices. There might be a simpler way to do it (I remember reading it once a while back <grin>), anyone else??? 🙂

What goes in here?

While($row = @mysql_fetch_array($result)) {
While(List($key, $val)=each($row)) {
if (!is_int($key)) {
$selectresults .= "$key: $val\n";
}
}
$selectresults .= "\n\n";
}

John Cornett

Anon

Thanks, I really appreciate your help. 🙂