Facebook-Like Activity Stream
I wrote an application, its not a social networking script by any means, but my script does have "user profiles" for it and I'm interested in a SQL/PHP design idea to go about activity streams as seen on Facebook for the users of my script.

Activities such as "Joey commented on X's wall." or "Joey, X, Foo like your photo" or "Foo changed his picture [picture here]"

I want it to be dynamic, not static entries, because if Joey changes his name to something else, I don't want it to show old data.

So, if you would please, help me out with a way to design this... I don't need any code just a push in the right direction.

Thanks alot!
Facebook-Like Activity Stream
===

I wrote an application, its not a social networking script by any means, but my script does have "user profiles" for it and I'm interested in a SQL/PHP design idea to go about activity streams as seen on Facebook for the users of my script.

Activities such as "Joey commented on X's wall." or "Joey, X, Foo like your photo" or "Foo changed his picture [picture here]"

I want it to be dynamic, not static entries, because if Joey changes his name to something else, I don't want it to show old data.

So, if you would please, help me out with a way to design this... I don't need any code just a push in the right direction.

Thanks alot!