08-29-2010, 10:00 AM
|
#1 (permalink)
|
|
The Wanderer
Join Date: Jun 2009
Location: Dubai, UAE
Posts: 23
Thanks: 2
|
PHP Get data from multi table
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
|
|
|
Join the friendly bunch on IRC...
Threaded Mode
