looking for a search script

[mrdeleigh]

Hi

I have a blog that has many bloggers and I'm looking for a script that looks like google ads, so when you open a blog it runs down the side and displays all other blogs that has simular content. (most recent at the top ) can anyone help me?

 

Thanks mrdeleigh

[MadTechie]

basically MySQL + Timestamp..

[penguin0]

and when you are displaying the blogs do ORDER BY $yourtimestampvar

[mrdeleigh]

think I'm in over my head here!!!

 

does anyone have a sample?

[MadTechie]

knew that was comming..

without knowing you system.. we can't suggect anything..

 

its just a case of adding a field (type date),

then tweaking the sql statement..

 

maybe if you posted some code..!

[Dragen]

but he's not wanting it ordered by date.. He wants to list blogs that are similar to the currently viewed one.. I think

 

I guess you could have a field in the table called 'keywords' or similar and then the sidebar could just display the first 5 (or however many) bloggs that have some of thte same keywords.

[mrdeleigh]

thanks for the replys

 

but he's not wanting it ordered by date.. He wants to list blogs that are similar to the currently viewed one.. I think

 

I guess you could have a field in the table called 'keywords' or similar and then the sidebar could just display the first 5 (or however many) bloggs that have some of thte same keywords.

 

thats correct but instead of keywords can it search the blog text?

[Dragen]

I guess you could, but it would be more difficult because you'd need some way of detecting certain words, otherwise you'll probably end up with lots of blogs that include the words 'and', 'the', 'it', etc.

[mrdeleigh]

otherwise you'll probably end up with lots of blogs that include the words 'and', 'the', 'it', etc.

 

good point can it be done?

[Dragen]

yes, but it'll be difficult. You'd need a search function which goes through each blog and checks it for words similar to in the blog being displayed.. I guess you could get it to filter out certain words from the search.

[mrdeleigh]

does anyone have a sample of this?

[MadTechie]

try yourself and when you get stuck post what you have..

[mrdeleigh]

I'm a complete newbie with this so I would not know where to start with this anyone got an idea?

[Dragen]

try google.

I've given you some ideas of where to start. Try searching for similar things, you might find a tutorial.

 

You need to look into databases, and forms using php.

[jamina1]

You could also just add keywords to your blog posts, and it could list posts with the same keywords by their date. That would be simplest.

[Dragen]

You could also just add keywords to your blog posts, and it could list posts with the same keywords by their date. That would be simplest.

already been suggested

 

but he's not wanting it ordered by date.. He wants to list blogs that are similar to the currently viewed one.. I think

 

I guess you could have a field in the table called 'keywords' or similar and then the sidebar could just display the first 5 (or however many) bloggs that have some of thte same keywords.

[Barand]

You could use a FULLTEXT search, which ignores words less than 4 chars long. Have a play with this

 

::DATA::

CREATE TABLE `blog` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `blogdate` date NOT NULL,
  `content` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `FTIndex_2` (`content`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `blog` (`id`,`blogdate`,`content`) VALUES 
(1,'2007-01-01','Dolphins are aquatic mammals'),
(2,'2007-01-05','Gerbils are mammals'),
(3,'2007-01-10','bullrushes are aquatic plants'),
(4,'2007-01-15','My friend plants trees for a living'),
(5,'2007-01-20','My garden shed is built of bullrushes'),
(6,'2007-01-25','Dolphins are your friend');

 

::SCRIPT::

<?php
include '../test/db2.php';
if (isset($_GET['id']))
{
    $id = $_GET['id'];
    $sql = "SELECT id, blogdate, content
            FROM blog
            WHERE id = '$id' ";
    $res = mysql_query($sql) or die (mysql_error()."<p>$sql</p>");
    if (list ($id, $d, $c) = mysql_fetch_row($res))
    {
        echo '<b>', date('jS F', strtotime($d)), '</b><br>', $c, '<hr><b>Similar blog entries</b><hr>';
        
        $sql = "SELECT blogdate, content
                FROM blog
                WHERE MATCH(content) AGAINST('$c')
                AND id <> '$id'
                ORDER BY blogdate DESC";
        $res = mysql_query($sql) or die (mysql_error()."<p>$sql</p>");
        while (list ($d, $c) = mysql_fetch_row($res))
        {
            echo '<b>', date('jS F', strtotime($d)), '</b><br>', $c, '<br><br>';
        }
        echo '<hr>';
    }
}
?>
<form>
Select a blog record (1-6)
<input type='text' name='id' size='4'>
<input type='submit' name='action' value='Submit'>
</form>