I am having trouble with a part of my php script. My users have comments and they make posts. I have a userTable, commentTable, and postTable. I need my user profile page to go something like facebook's profile page. The comments and posts involving this user need to be intertwined and ordered by date (DESC). It is not as simple as tweaking the SQL because there are 3 tables involved. I believe I need to create a php function and work it out that way, but I can't get it working right.
The 3 tables and the info that is important with this problem:
userTable: user_id, username
postTable: post_id, user_id, post_date
commentTable: user_id, comment_date, commenting_userid, commenting_username
7/14 john said hello, world [commentTable]
7/13 bob said foo [commentTable]
7/12 you added a new post to buy socks [postTable]
7/11 steve said bar [commentTable]
If you can help me, please let me know.
26 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
Hello. I already have a script that i developed in a past project that does exactly the same job. I'll just have to customize it for you. Just a couple of hours. Sincerely.
We are a group of 3 expert PHP and MySQL developers. We have experience developing social networking sites. This is not an issue for us. Just some 1 or 2 hours and you'll have your work done !!!