SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Feb 2006
    Posts
    51
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Query for "Most read authors"

    Hello,

    I would like to show most readed authors from database (mysql)... but i don't know how to make query...

    I have 2 tables: authors(id) | articles(uid,count)

    I would like to query most readed authors based on articles(field: count)...

    How can i make this?

    Thank you!

  2. #2
    SitePoint Guru hifigrafix's Avatar
    Join Date
    Oct 2005
    Location
    Nashville, TN
    Posts
    628
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    is uid an id that is tied to the authors table? or is uid the id of the article?

  3. #3
    SitePoint Enthusiast
    Join Date
    Feb 2006
    Posts
    51
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Quote Originally Posted by hifigrafix View Post
    is uid an id that is tied to the authors table? or is uid the id of the article?
    table "users": id -> id of author

    table "articles": uid -> id of author submited article, count -> number of article readed


Bookmarks

Posting Permissions

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