Hello Everyone,
This is a great module set. I have the birthday module working.
I hope someone can give me some help on a new module I am writing.
I have created another query in the new module
$query_message_raw = "select m.id, m.date_created, md.message_id, md.message_name
from " . TABLE_MESSAGES . " m, " . TABLE_MESSAGES_DESCRIPTION . " md
where m.id = md.message_id and date(m.date_created)=date(now()) ORDER BY date(m.date_created) ASC";
$query_message = mh_db_query($query_message_raw);
this query gets the quote for the day to email to anyone who signs up for it.
I can't get the message_name (which is the quote for the day) to appear in the body of the email. Everything else works.
Any help at all would really be appreciated. Thank you in advance - Skylark