Related Searches

Discussion in 'PHP' started by jovany, Nov 12, 2009.

0
  1. #1
    I want a php function to display related searches when doing search for specified term and to control the number of those related searches for example 10 terms

    plz help me quickly as i need it

    and also i need another php function to display the last 50 words searched by users to be displayed on the homepage


    thanks in advance
     
    jovany, Nov 12, 2009 IP
  2. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #2
    use match against on the column you wish to search and order the result based on relevancy..

    for latest 50 keywords, store every search in a table with user's IP, timestamp, keyword searched and other relevant details. Then do a query and order the result by timestamp in descending order.

    if you have table structures ready, share those with us and we can give you exact queries..
     
    mastermunj, Nov 12, 2009 IP
  3. jovany

    jovany Peon

    Messages:
    78
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    thanks friend but unfortunatly iam not good at phph i want you to present the phph codes for those functions
     
    jovany, Nov 13, 2009 IP
  4. mastermunj

    mastermunj Well-Known Member

    Messages:
    687
    Likes Received:
    13
    Best Answers:
    0
    Trophy Points:
    110
    #4
    please share your table structures and sample data so that we can help you with queries and php scripts.
     
    mastermunj, Nov 13, 2009 IP