howto: email db entries

[Anonymouz]

I want to know if it`s possible to send an email with the data from 4 fields in the database

I`ve got a poll with 4 possible answers, i want an email to be sent every hour with these 4 entries.

Is this possible?

[insane]

It IS possible to send an email with data from a database. It's not possible to have an email sent eyery hour with PHP, except with crontab or alike. Why would you want to do that anyway? I'd have an email sent everytime someone answers the poll.

Sending Email:

$query = "SELECT field1, field2, field3, field4 FROM polltable WHERE id ='$your_id'";
$result = mysql_result($query);
$array = mysql_fetch_array($result);


$mail_text = "Field 1: $array[field1]\nField 2: $array[field2]\nField 3: $array[field3]\nField 4: $array[field4]\n";

mail("[e-mail]","Subject",$mail_text);