Results 1 to 7 of 7

Thread: MySQL SQL Query I can not slove it

Hybrid View

  1. Feb 7th, 2009, 12:45 AM #1
    manavo11
    manavo11 is offline
    Super Moderator manavo11's Avatar
    Join Date
    Nov 2002
    Location
    Around the corner from si_the_geek
    Posts
    7,171

    Re: MySQL SQL Query I can not slove it

    Quote Originally Posted by dclamp
    You need to use a JOIN.

    Code:
    SELECT * FROM Users LEFT JOIN News WHERE Users.UsersID = News.NewsID LIMIT 3;
    The comma between the table names is equivalent to "inner join".


    Has someone helped you? Then you can Rate their helpful post.
    Reply With Quote Reply With Quote
  2. Feb 7th, 2009, 09:07 AM #2
    prokhaled
    prokhaled is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jan 2002
    Posts
    259

    Re: MySQL SQL Query I can not slove it

    this also dispaly 3 news only for the first users in the table like:
    username1
    news1
    news2
    news3

    but I need to display all user and 3 news under every user like:

    username1
    news1
    news2
    news3

    username2
    news1
    news2
    news3

    username3
    news1
    news2
    news3

    username4
    news1
    news2
    news3
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width