Just A Lil Bit Help!!

[khan]

Hei Guyz, I have a problem while code a page.
We can see that in facebook, there is comments in Users status or wall posts.I tried to create a thing for me.But while doing this i got a problem in me.
That is, when a B commented a status of a user A, I can send that user A a notification.But when that user A commented on his status, i cant send any notification to B. I only can send notification to both user A and B.
But i need to do this only for B.
How can I do this??
Any Idea??
My sql is like
ID, Name, Comment, Statref, Time.
My head is full of rubz.

[wapmetal]

lol this is not little....

[Loony]

add a new filed to ur sql have 1 for each user a and b when user b posts on a's wall it notifies a by pulling name from table and do the same for when a posts on b's wall

[khan]

@loony, i did that but it only notify 1 person A or B. But i need to notify all that id who commented on that wall posts or status.
@wapmetal, hehehe i havent ny idea for that. Thats why its lil....hehe

[Loony]

hmmmm use the comment id then everytime someone post everyone that has the same id gets a notification so if it was 1 then have a field in sql for comment id so ur using to ids.

do u understand what i mean??

[thanatos]

is these for lavalair? if it is.. examine the coding for guestbook or gallery..

$ownerid = select uid from table where comment_id='id'; if($uid!==$ownerid[0]){ insert comment blah blah.. insert notification}else{ you cnt comment ur own }

this should gve u an idea. its all done!

[kiLLeR-eyEd_14]

Yeh..Thanatos has gave u an idea..Just to add more idea..use autopm function to notify the user when someone commented or liked his/her status..

autopm(getnick_uid(id of the user who commented here)." commented on your <a href=\"link to ur status\">status</a>",ur id here); 

[Nahar]

Nice..
@khan Can u Post Full Of Script Function Here :D

[khan]

@thanatos and killer,unfortunately if i follow ur idea, then user A cant comment on his own wall post.
But my problem is there. I need user A can comment on his status or whatever but he ll not get ny ntification.and if user C commented on user A s status and when A commented on the same status, then It will send a notification to the user C not A.
@loony, i got ur idea but seems it will not workin.
This thing is like as facebook.I tried it last two days.but failed.

[khan]

@nahar, once ill finish the full code, ill share. But i m nt using LAVALAIR.

[thanatos]

Follow the code i gave u.. just change "u cnt comment ur own" with the insert query for da comment but without the query for noti.. simple isnt it?

[Loony]

[QUOTE=khan89;56823]@thanatos and killer,unfortunately if i follow ur idea, then user A cant comment on his own wall post.
But my problem is there. I need user A can comment on his status or whatever but he ll not get ny ntification.and if user C commented on user A s status and when A commented on the same status, then It will send a notification to the user C not A.
\

thats all something that a few if's and else's would fix look at the code when the user post on own status no notification if the comment id is higher then 1 meaning that his commenting after the original comment then it sends notification.
if thats not understandable add me on msn ill explain it a bit better msn ( looony_guy79@hotmail.com )

[ksg91]

i would recommend create a separate table for notifications.

[khan]

@ksg91, yeah... i m using separete notification table. but its not up clearly.

[something else]

example:

$list = mysql_query("SELECT name FROM comments WHERE postid='".$postid."' AND name!='".$yourname."'");
while($list=mysql_fetch_array($list)){

mysql_query("INSERT INTO notifactions SET name='".$list[0]."', postid='".$postid."', date='".time()."', whoposted='".$yourname."'");

}