www.webdeveloper.com
Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20

Thread: Facebook like news feed

  1. #16
    Join Date
    Apr 2007
    Posts
    1,664
    Quote Originally Posted by svidgen View Post
    Haha ... I don't even have time to work on my sites ...
    lol, now I hear you on that one. My personal sites 'to do' list is so big it's ridiculous!!
    Anti Linux rants are usually the result of a lack of Linux experience, while anti Windows rants are usually a result of a lot of Windows experience.

  2. #17
    Join Date
    Jun 2009
    Posts
    7
    svidgen i'm paying. plus book or no book, my skills aren't where they need to be to figure any of that stuff out and i don't want to wait months to learn the stuff to get the site up. i was really hoping to have it up within the next 1-2 months, and people with expertise like you and syco are the only way thats going to happen for me.

    help me out?

  3. #18
    Join Date
    Jan 2007
    Location
    Wisconsin
    Posts
    2,120
    ... I'm not sure this type of proposition is allowed in this forum.

    In any case, I'm working a temp position doing web development at the moment. If you're still looking for help mid-July, feel free to send me a PM, I guess. If they don't have enough work to keep me permanently, I'll be looking for freelance work again.
    Jon Wire

    thepointless.com | rounded corner generator

    I agree with Apple. Flash is just terrible.

    Use CODE tags!

  4. #19
    Join Date
    May 2008
    Posts
    50
    OK, I'm kind of in the same boat (I just read every post, too).

    I would call myself decent at PHP now. I have a news feed on my site, which has rows inserted in a feed table. For the user's profile, we pull where the activity (activeUser column) was done by that user. For the main feed, we pull stories according to the activeUser where those are your friends.

    Now, I'm trying to make the feed more 'relevant' by:
    1. Finding out which user's profile you've visited most (also recorded in MySQL, one row for each view containing the profile ID, viewer ID and time).
    AND THEN
    2. Pull stories about your friends according to how interested you are in them, to a total of 30 stories in the feed.

    I'd like a little variety so that it still pulls based on your friends list and includes a little more about the people you're most interested in.

    Here's the original query:
    Code:
    SELECT 
    profileGossip.*, profileFans.* 
    FROM 
    profileGossip, profileFans 
    WHERE 
    profileFans.artist=profileGossip.activeUser AND
    (profileFans.fanID='{$_SESSION['id']}' OR profileGossip.newsStory='16' OR profileGossip.newsStory='25' OR profileGossip.newsStory='27') OR (profileGossip.activeUser='{$_SESSION['id']}' AND
    profileGossip.newsStory='2') OR (profileGossip.activeUser='{$_SESSION['id']}' AND profileGossip.newsStory='31') 
    ORDER BY gosID DESC 
    LIMIT 30
    And here's the new garbled mess of a query that I'm struggling with:
    Code:
    SELECT 
    profile_views.view_id, profile_views.profile_id, profile_views.viewer_id, profileFans.artist, profileFans.fanID, profileGossip.*, 
    COUNT(profile_views.profile_id) AS profile_ranks 
    FROM 
    profile_views, profileGossip, profileFans 
    WHERE
    profile_views.viewer_id=profileFans.fanID AND 
    profileFans.fanID='$user_real_id' AND 
    profile_views.profile_id=profileFans.artist AND 
    profileFans.artist=profileGossip.activeUser 
    GROUP BY profile_ranks 
    ORDER BY profileGossip.timeActivity DESC 
    LIMIT 30
    Any advice?
    Last edited by ckts; 08-31-2009 at 10:29 AM.

  5. #20
    Join Date
    Jun 2009
    Posts
    7

    Help me out

    At this point you are lightyears ahead of me. Mind helping a fellow webpreneur out (I'm 99.99999% sure we are NOT in the same business)?

    I've gone through 3 lame-duck developers, one guy who I think could have done it but wanted five figures (not counting the pennies) and banged my head against the wall trying to understand stuff way above my head.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center



Recent Articles