Closed

Newsfeed Section - repost

This project received 12 bids from talented freelancers with an average bid price of $177 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
12
Project Description

Hi

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:

Likes
Share
Pictures
Status
Followers
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
follow.fUser1='5') );

Any assistance can be appreciated in solving this issue, your services will be compensated for sure.

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online