select id, name, passwd
from members
where name = '#form.name#'
and passwd = '#form.passwd#'
insert into members (name, passwd, email)
values ('#name#','#passwd#','#email#')
Welcome #form.name#,
Thank you for joining our eeFar.com forum, please click on the link below to activate your account.
[Click here]
Thank you,
select s.title, s.message, s.timestamp, m.name
from messages s left outer join members m on s.m_id = m.id
order by timestamp desc
EEFAR Forum