Käynnissä

List a users comments and post ordered by date, 3 tables

Hello,

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

I want:

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.

Brad

Taidot: PHP

Näytä lisää: sql get date, want create facebook page, steve, steve s, Socks, hello world, facebook post, facebook comments, desc, brad, as 3, post world, post php script facebook, script facebook post, user list, facebook post script, hello bar, list post, page list, profile post, buy facebook profile, facebook post function, create facebook posts, php post facebook page, post facebook page php

About the Employer:
( 8 reviews ) St. Louis, United States

Projektin tunnus: #469436

Myönnetty käyttäjälle:

VeritatisDevNet

Sure it can be done with sql and php. However, there's some issues to be clarified. Please kindly check pm.

33 $ USD 1 päivässä
(1 arvostelu)
1.0

26 freelanceria on tarjonnut keskimäärin 60 $ tähän työhön

univane

Hi, We are ready to start work. Please see PMB for more details....... Regards, Nishant

40 $ USD 0 päivässä
(22 arvostelua)
4.4
Fherjam

I can help you create the function to get the comments to, and posts of a user ordered by date as you need from those tables.

35 $ USD 1 päivässä
(9 arvostelua)
4.0
thepanister

I have did it already! please check pm!

50 $ USD 5 päivässä
(9 arvostelua)
0.0
davjammy

I am ready to start. No more than 1 day.

30 $ USD 0 päivässä
(0 arvostelua)
0.0
thesoftmakers

We are a group of 3 PHP and MySQL web developers. This project is sooo simple ! It won't last for more than 2 hours.

30 $ USD 0 päivässä
(0 arvostelua)
0.0
codethinkers

"We think in code". Maximum 2 hours. We have a sample code with us. Regards.

30 $ USD 0 päivässä
(0 arvostelua)
0.0
softsons

Very good description. And very easy task. Just allow us some 3 hours max for delivery. Sincerely.

30 $ USD 0 päivässä
(0 arvostelua)
0.0
sisisoft

Just one hour ... and everything's OKAY. I have an EXACT sample code. I'll just customize it as you want.

30 $ USD 0 päivässä
(0 arvostelua)
0.0
becode

This is a verryyy easy task. I don't have to advertise anything. I do it within 2 hours max.

30 $ USD 0 päivässä
(0 arvostelua)
0.0
rjahadson

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.

50 $ USD 0 päivässä
(0 arvostelua)
0.0
expertcoders

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 !!!

30 $ USD 0 päivässä
(0 arvostelua)
0.0
Codimson

Very easy task ! I deliver the project within a couple of hours !

30 $ USD 0 päivässä
(0 arvostelua)
0.0
rapidshare

I believe to solve to soon. Check my PM.

30 $ USD 0 päivässä
(0 arvostelua)
0.0
Indiawisdom

IndiaWisdom is a web development company located in New Delhi,India. Our success is determined by how successfully we meet our client needs. Our goal is to serve our client and exceed their expectations, thereby streng Lisää

225 $ USD 2 päivässä
(0 arvostelua)
0.0
tiblug

Hi I have 4+ years experience in php.I have work on many framework like cake php,joomla,smarty ,Magento etc.I can do your work with full customer satisfaction.Please give me one chance. I have created facebook type Lisää

250 $ USD 3 päivässä
(0 arvostelua)
0.0
cynicaltear

Sir, I am willing to provide you with my services. Though I'm a newbie on odesk but I do have sound knowledge of web designing and working on 3 websites currently (one is image uploading website,one is a forum bas Lisää

30 $ USD 2 päivässä
(0 arvostelua)
0.0
shahadatsm

Dear Sir Please check the PM

35 $ USD 1 päivässä
(0 arvostelua)
0.0
rockstarweb

Hi, my name is Matthew and I'm from the USA. I'd love to solve this problem for you. Will communicate via AIM and email if you select my bid. This is a simple issue I've solved many times before. I'm skilled with php a Lisää

35 $ USD 1 päivässä
(0 arvostelua)
0.0
dmytryd

Dear Brad, As long as i understood, you need to list the user's posts, and other users' comments regarding that user merged together and sorted by date in descending order. I would like to undertake this project. Lisää

35 $ USD 1 päivässä
(0 arvostelua)
0.0
gyengus

Ready to work.

39 $ USD 0 päivässä
(0 arvostelua)
0.0