looking for kind soul (mysql querry)

Discussion in 'PHP' started by izlik, May 14, 2008.

  1. #1
    Hello

    Im looking for a very kind person to make me a fast mysql query

    what i need is a query that checks the words in the table "words" and diplayes the top 3 words used and the possiblebility to get redirected to http://mypage.com/words.php?=[word pressed] when the word in top is pressed.

    i hope someone can help me :)
     
    izlik, May 14, 2008 IP
  2. pozzad

    pozzad Member

    Messages:
    7
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #2
    Could you post the "words" table structure?
     
    pozzad, May 14, 2008 IP
  3. Barti1987

    Barti1987 Well-Known Member

    Messages:
    2,703
    Likes Received:
    115
    Best Answers:
    0
    Trophy Points:
    185
    #3
    
    $get_list = mysql_query("SELECT * FROM `word_list` ORDER BY `word_hits` DESC");
    while($each = mysql_fetch_assoc($get_list)){
         echo "<a href=\"word.php?word=".$each['word_title']."\">".$each['word_title']."</a>";
    }
    
    PHP:
    Peace,
     
    Barti1987, May 14, 2008 IP
  4. izlik

    izlik Well-Known Member

    Messages:
    2,399
    Likes Received:
    50
    Best Answers:
    0
    Trophy Points:
    185
    #4
    thanks a lot m8! rep added, thank you very much! :)
     
    izlik, May 14, 2008 IP