Search

--Boundary_(ID_sk6LziDCJuxocrhvOtmw7Q)
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT
Content-disposition: inline



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 b
e used or reproduced in any manner whatsoever.


--Boundary_(ID_sk6LziDCJuxocrhvOtmw7Q)
Content-Type: text/plain; charset=us-ascii

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--Boundary_(ID_sk6LziDCJuxocrhvOtmw7Q)--

Re: Search

There's so many correct answers to your question that I don't really=20
want to broach the subject. There's enough to that question that could=20
fill several volumes.

Take a look at the FULLTEXT search functionality of MySQL just for a=20
taste of what goes into such things. This is likely not your answer, but =

the description of the functionality can introduce you to some of the=20
concepts.

-Micah

On 03/12/2007 08:45 PM, MIGUEL ANTONIO GUIRAO AGUILERA wrote:
> Hi my friends,
>
> I have a web site where visitor should be able to look for specific doc=
uments: 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 qu=
ien esta dirigido; contiene informacion estrictamente confidencial y lega=
lmente 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 pres=
ente, que su reproduccion y distribucion, esta estrictamente prohibida. S=
i Usted recibio este comunicado por error, favor de notificarlo inmediata=
mente al remitente y destruir el mensaje. Todas las opiniones contenidas =
en este mail son propias del autor del mensaje y no necesariamente coinci=
den con las de Radiomovil Dipsa, S.A. de C.V. o alguna de sus empresas co=
ntroladas, controladoras, afiliadas y subsidiarias. Este mensaje intencio=
nalmente 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 pro=
tected material whose disclosure is subject to penalty by law. If the pe=
rson 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 pe=
rson is herein notified that any unauthorized dissemination, distribution=
or copying of the materials included in this facsimile is strictly prohi=
bited. If you received this document by mistake please notify immediate=
ly to the subscriber and destroy the message. Any opinions contained in t=
his 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 contr=
ol, controlled, affiliates and subsidiaries companies. No part of this me=
ssage or attachments may be used or reproduced in any manner whatsoever.
>
> =20

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Search

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" wrote in
message news:f610d7c34a16.45f5bbf5@mail.telcel.com...
>
>
> 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