i'm working on ERP Solutions and want to inform if any one have unread notification and i want send one email daily if anyone not read notification. one email in one day each member who have unread notifications.

My Query

"select n.*, i.* from ew_notifications n, ew_inform i where n.authorid<>i.authorid and i.senddate<>'$todatdate' "


if($resords>0){

insert into ew_inform (authorid, senddate) value('{$resords['authorid']}', '$todatdate')

}


error this my query showing again tha member that exiting in ew_inform table i just want that pplz come who dont exsit in ew_inform table in current date

__________________
==========================================
http://paysha.com/Pakistan/Sialkot/Profiles/100171.html
==========================================