1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

SQL Help needed

Discussion in 'Databases' started by wizzard, Sep 4, 2006.

0
  1. #1
    Hello,

    I'm have 2 tables as follow my users table and my online_users table.

    I want to show on my pages my online users first and under this the offline users. So i work with a LEFT JOIN to select my online users first but i don't know how i can first show my online users random. If i do order by rand() then it doesn't show the online first but the whole members table random.

    I work also via a navigation with 100 users per page.

    Does someone knows a working solution?
     
    wizzard, Sep 4, 2006 IP
  2. wizzard

    wizzard Peon

    Messages:
    160
    Likes Received:
    6
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Anyone ???
     
    wizzard, Sep 4, 2006 IP
  3. swirl1980

    swirl1980 Peon

    Messages:
    53
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    can u not just do 2 seperate queries??
     
    swirl1980, Sep 4, 2006 IP
  4. hextraordinary

    hextraordinary Well-Known Member

    Messages:
    2,171
    Likes Received:
    115
    Best Answers:
    0
    Trophy Points:
    105
    #4
    rand will work on the entire query result, two queries will work nicely in this case.
     
    hextraordinary, Sep 4, 2006 IP
  5. ccoonen

    ccoonen Well-Known Member

    Messages:
    1,606
    Likes Received:
    71
    Best Answers:
    0
    Trophy Points:
    160
    #5
    Do your first query, appy the RAND() function to it so your records are random. Then do a Union to the next query.
     
    ccoonen, Sep 7, 2006 IP