If the article copy is stored in the db, and you've got sql to work
with, then at the
point of publication of a new article, it might be possible to narrow
the targets
with;
select id from articles where article_text like %valley forge%";
(or something like that).
Then you can do whatever you need to on only those ids.
That might avoid the overhead of selecting the content of all the
articles for
processing in php.
On Aug 27, 2009, at 4:26 PM, Randal Rust wrote:
On Thu, Aug 27, 2009 at 4:16 PM, Andrew Muraco<[email protected]>
wrote:
Personally, i think a spider/bot is the best bet, maintain a list of
phrases/words that should point to links and add those in.
I am leaning towards thinking that is the best option. The other way
would be to simply provide the editor with a button they can click
that automatically does the updates and then provides a list of
articles that they need to review. If all is good, then they can
approve and publish.
--
Randal Rust
R.Squared Communications
www.r2communications.com
614-370-0036
_______________________________________________
New York PHP User Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
http://www.nyphp.org/show_participation.php
_______________________________________________
New York PHP User Group Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
http://www.nyphp.org/show_participation.php
