A bit of a newbie question here:
Im building a search engine on php and mysql using a keyword search. Im spliting the keywords at the spaces and searching for each individual keyword eg. if I search for broom stick, I split it into broom and stick then serach for broom then stick but if a listing has the keywords broom and stick it comes up twice, and if I search for room I still get the same results.