Hello, I wrote a thesis search engine in my university. You can try this search engine from http://www.fbe.gazi.edu.tr/tezara/ web address. In my application, I seperated keyword of any thesis with quote and then I inserted this keyword to the thesis table. In this table I also inserted other thesis information such as student name, advisor, deparment code and so on then I developed search engine module. In this module, I looked search keyword in my table and I used GROUP BY and COUNT SQL expressions then I sorted thesis for count of search keyword in the thesis table descending order. This is simple, easy and very useful searching method:) -- Haydar TUNA Republic Of Turkey - Ministry of National Education Education Technology Department Ankara / TURKEY Web: http://www.haydartuna.net "MIGUEL ANTONIO GUIRAO AGUILERA" <miguel.guirao@xxxxxxxxxxxxxxx> wrote in message news:f610d7c34a16.45f5bbf5@xxxxxxxxxxxxxxxxxx > > > Hi my friends, > > I have a web site where visitor should be able to look for specific > documents: articles, sermons, etc I want to provide the capability to > search by keywords, but I have never worked with this kind of search. > > Any ideas of what I should store in my tables? > How to create my query?? Should I have a keywords field in he table?? > > Best Regards, > > ------------------------------------------------ > MIGUEL GUIRAO AGUILERA > Logistica R8 - Telcel > Tel: (999) 960.7994 > > > Este mensaje es exclusivamente para el uso de la persona o entidad a quien > esta dirigido; contiene informacion estrictamente confidencial y > legalmente protegida, cuya divulgacion es sancionada por la ley. Si el > lector de este mensaje no es a quien esta dirigido, ni se trata del > empleado o agente responsable de esta informacion, se le notifica por > medio del presente, que su reproduccion y distribucion, esta estrictamente > prohibida. Si Usted recibio este comunicado por error, favor de > notificarlo inmediatamente al remitente y destruir el mensaje. Todas las > opiniones contenidas en este mail son propias del autor del mensaje y no > necesariamente coinciden con las de Radiomovil Dipsa, S.A. de C.V. o > alguna de sus empresas controladas, controladoras, afiliadas y > subsidiarias. Este mensaje intencionalmente no contiene acentos. > > This message is for the sole use of the person or entity to whom it is > being sent. Therefore, it contains strictly confidential and legally > protected material whose disclosure is subject to penalty by law. If the > person reading this message is not the one to whom it is being sent and/or > is not an employee or the responsible agent for this information, this > person is herein notified that any unauthorized dissemination, > distribution or copying of the materials included in this facsimile is > strictly prohibited. If you received this document by mistake please > notify immediately to the subscriber and destroy the message. Any > opinions contained in this e-mail are those of the author of the message > and do not necessarily coincide with those of Radiomovil Dipsa, S.A. de > C.V. or any of its control, controlled, affiliates and subsidiaries > companies. No part of this message or attachments may be used or > reproduced in any manner whatsoever. > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php