[Pugged] Related Resources
Chris Hettinger
ciapug@ciapug.org
Fri, 28 Mar 2003 08:35:15 -0600
This is a multi-part message in MIME format.
------_=_NextPart_001_01C2F537.3F9F3D7F
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hello PHPers...
=20
I would like some input on a project that I am just starting. I would =
like feedback telling me if I am on the best path for this scenario, and =
if not recommendations are welcomed.
=20
The project in summary... I have a database table containing articles =
(title, article, keywords...). On the viewing end, when an article is =
viewed on the web site I have a area designated for "Related Resources."
=20
The path that occurred to me to create this list of related resources =
was to include a field for each article that contained a comma separated =
list of keywords. When the page is requested a process would select the =
article they are viewing, then when I create the related resources =
listing I would take the value of the keywords list from the selected =
article, and have to do a comparison to the keywords listing for all of =
the other articles. Where a keyword matched, I would then include that =
article as a related resource.
=20
So am I considering the best method for doing this? This seems like it =
could become a very inefficient query as my db table grows.
=20
Thanks for any input.
=20
-Chris Hettinger
=20
The information in this e-mail is the property of Employee and Family =
Resources. It is considered confidential, may be legally privileged, =
and is intended only for the addressee. If you are not an addressee, =
you are not authorized to read, copy or use the e-mail or any =
attachment. If you have received this e-mail in error, please notify =
the sender by return e-mail and then destroy the e-mail.
=20
=20
------_=_NextPart_001_01C2F537.3F9F3D7F
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<HTML xmlns:eXclaimer=3D"http://www.exclaimer.co.uk" =
xmlns:o=3D"urn:schemas-microsoft-com:office:office">
<HEAD>
<META http-equiv=3D"Content-Type" content=3D"text/html; =
charset=3DUTF-16">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUTF-16">
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4916.2300" name=3DGENERATOR></HEAD><BODY =
><DIV>
<DIV><SPAN class=3D103442114-28032003><FONT face=3DArial size=3D2>Hello=20
PHPers...</FONT></SPAN></DIV>
<DIV><SPAN class=3D103442114-28032003><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D103442114-28032003><FONT face=3DArial size=3D2>I =
would like some=20
input on a project that I am just starting. I would like feedback =
telling me if=20
I am on the best path for this scenario, and if not recommendations =
are=20
welcomed.</FONT></SPAN></DIV>
<DIV><SPAN class=3D103442114-28032003><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D103442114-28032003><FONT face=3DArial size=3D2>The =
project in=20
summary... I have a database table containing articles (title, =
article,=20
keywords...). On the viewing end, when an article is viewed on the web =
site I=20
have a area designated for "Related Resources."</FONT></SPAN></DIV>
<DIV><SPAN class=3D103442114-28032003><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D103442114-28032003><FONT face=3DArial size=3D2>The =
path that=20
occurred to me to create this list of related resources was to include a =
field=20
for each article that contained a comma separated list of keywords. When =
the=20
page is requested a process would select the article they are viewing, =
then when=20
I create the related resources listing I would take the value of the =
keywords=20
list from the selected article, and have to do a comparison to the =
keywords=20
listing for all of the other articles. Where a keyword matched, I would =
then=20
include that article as a related resource.</FONT></SPAN></DIV>
<DIV><SPAN class=3D103442114-28032003><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D103442114-28032003><FONT face=3DArial size=3D2>So am =
I considering=20
the best method for doing this? This seems like it could become a very=20
inefficient query as my db table grows.</FONT></SPAN></DIV>
<DIV><SPAN class=3D103442114-28032003><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D103442114-28032003><FONT face=3DArial size=3D2>Thanks =
for any=20
input.</FONT></SPAN></DIV>
<DIV><SPAN class=3D103442114-28032003><FONT face=3DArial=20
size=3D2></FONT></SPAN> </DIV>
<DIV><SPAN class=3D103442114-28032003><FONT face=3DArial size=3D2>-Chris =
Hettinger</FONT></SPAN></DIV></DIV>
<DIV STYLE=3D"FONT-SIZE: 7pt; COLOR: gray; FONT-FAMILY: verdana">
<P CLASS=3D"MsoNormal" STYLE=3D"MARGIN-LEFT: 0.5in">
<FONT FACE=3D"Verdana" COLOR=3D"black" SIZE=3D"1"><SPAN =
STYLE=3D"FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Courier =
New'"><SPAN STYLE=3D"FONT-SIZE: 8pt; COLOR: black; FONT-FAMILY: Verdana; =
mso-fareast-font-family: 'Times New Roman'; mso-bidi-font-family: =
'Courier New'; mso-bidi-font-size: 10.0pt; mso-ansi-language: EN-US; =
mso-fareast-language: EN-US; mso-bidi-language: AR-SA">The information =
in this e-mail is the property of Employee and Family Resources.<SPAN =
STYLE=3D"mso-spacerun: yes"> </SPAN>It is considered confidential, may =
be legally privileged, and is intended only for the addressee.<SPAN =
STYLE=3D"mso-spacerun: yes"> </SPAN>If you are not an addressee, you =
are not authorized to read, copy or use the e-mail or any =
attachment.<SPAN STYLE=3D"mso-spacerun: yes"> </SPAN>If you have =
received this e-mail in error, please notify the sender by return e-mail =
and then destroy the e-mail.</SPAN></SPAN></FONT>
</P>
</DIV></BODY></HTML>
------_=_NextPart_001_01C2F537.3F9F3D7F--