So where is the perl portion?  All this code does is makes two tables,
and a simple select statement.  Where is the data, where is the
interface, what does perl have to do with it?

On Tue, Jan 28, 2003 at 03:49:13PM -0800, Jacob Meuser wrote:
> I once wrote a (really simple) search engine in perl/mysql ...
> 
> I made a keyword ranking system ....
> 
> create table keywords
> (
>   keyword varchar(50) not null,
>   score int(5) unsigned not null,
>   url_id int(10) unsigned not null,
>   index(keyword, url_id)
> );
> 
> create table urls
> (
>   url_id int(10) unsigned not null auto_increment primary key,
>   url text not null
> );
> 
> select
>   urls.url
> from
>   keywords, urls
> where
>   keywords.keyword = '$keyword'
>   and
>   keywords.url_id = urls.url_id
> order by keywords.score desc;
> 
> So, the key in this system is parsing and ranking ...
> 
> Dunno know how google does it though :p
> 
> -- 
> <[EMAIL PROTECTED]>
> _______________________________________________
> Eug-LUG mailing list
> [EMAIL PROTECTED]
> http://mailman.efn.org/cgi-bin/listinfo/eug-lug
_______________________________________________
Eug-LUG mailing list
[EMAIL PROTECTED]
http://mailman.efn.org/cgi-bin/listinfo/eug-lug

Reply via email to