Need a small MySQL fix. instant $5

Discussion in 'Programming' started by heroic, Jul 18, 2010.

  1. #1
    Hi,

    I need a quick MySQL fix. For some reason this query is giving no results even though there is atleast 1 entry with the feeds.from = 1

    SELECT feeds.id,feeds.text,feeds.from,feeds.to,feeds.time FROM `feed_replies`,`feeds`,`friendships` WHERE ((feeds.from = '1') OR (feeds.to = '1') OR (friendships.from = '1' AND feeds.to = friendships.to) OR (feed_replies.from = '1' AND feed_replies.feed_id = feeds.id)) AND feeds.not_allowed NOT LIKE '%|1|%' ORDER BY feeds.time DESC LIMIT 15
    Code (markup):
    Thanx.
     
    heroic, Jul 18, 2010 IP
  2. heroic

    heroic Peon

    Messages:
    252
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #2
    This thread is closed. The fix was that there had to be atleast one entry in every table involved.
     
    heroic, Jul 18, 2010 IP
  3. Magina™

    Magina™ Active Member

    Messages:
    258
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    53
    As Seller:
    100% - 0
    As Buyer:
    100% - 0
    #3
    I miss this job. If you have more just let me know.
     
    Magina™, Jul 18, 2010 IP