Newsfeed Section - repost
- Status Closed
- Budget $30 - $250 USD
- Total Bids 12
We need some assistance in coding a function on our website that we are currently developing.
here is the problem in brief:
We have the following tables:
and other tables.
What is the SQL Query to load user activities that am following on my newsfeed section? we are building a newsfeed section just like the facebook one.
this is what we tried and it is not working:
SELECT * FROM users INNER JOIN likes ON ([url removed, login to view] = [url removed, login to view]) INNER JOIN status ON
([url removed, login to view] = [url removed, login to view]) WHERE EXISTS ( SELECT * FROM follow WHERE (like.uId=
[url removed, login to view] AND follow.fUser1='5') OR (status.uId= [url removed, login to view] AND
Any assistance can be appreciated in solving this issue, your services will be compensated for sure.Get free quotes for a project like this
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online