mYSQL query idea

Discussion in 'PHP' started by mdrobiul, May 29, 2009.

0
  1. #1
    I'm using a directory script that does not have the related site feature. I want to create the related sites listings at view link page. how i should match view link title with related sites..thanks
     
    mdrobiul, May 29, 2009 IP
  2. Sudoku-Master

    Sudoku-Master Peon

    Messages:
    54
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    without infos about your db structure no one can help you
     
    Sudoku-Master, May 30, 2009 IP
  3. d4xDragon

    d4xDragon Peon

    Messages:
    30
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #3
    that is complex job to do, see

    1) it is not necessary that URL of 2 similar sites are similar. for example i can have a directory hosted on domain "ilovejobs.xyz", if i will find the related sites for this then i will list " Love" and "Jobs" sites [which is also complex job to do.]

    2) you can match the Discription of sites. but how to match and what to march is Very very Difficult job,

    3) simplest things. for every directory script there is category table. you can simply select RANDOM records from category of link you are viewing and display.

    i hope that will help

    Thanks
    Dragon
     
    d4xDragon, May 31, 2009 IP
  4. mdrobiul

    mdrobiul Peon

    Messages:
    186
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    thanks brother, I already made the random listing. actually, mysql search has some what like exact phase, all words etc. this why it became difficult to create related sites by mysql search idea. i need to give more time on it.
     
    mdrobiul, Jun 6, 2009 IP