i wanted to make a search engine for my site ( and before you go on about google, i dont want it )

i have something very specific in mind, i want the search to include Search Suggestions alot like ask.com

so when they start typing, possible results come up,

let me show you what i have

my table is as follows

Code: Select all

CREATE TABLE `recipes` (
  `Id` mediumint(13) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `yield` varchar(255) NOT NULL default '',
  `instructions` text NOT NULL,
  PRIMARY KEY  (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=315743 ;

and i am going to make the results display within my sites template, linking to anther file that will pull the choosen result and display the recipe

so it is really just a search engine for my own site i suppose with Search suggestions

these results are coming from my database, does anyone know how this can be done ?

cheers

__________________
My Recipe forum...don't click here