Posted by Jim Moseby on 10/19/05 15:55

>
> Hi,
> guys I have two tables, articles and keywords, what I want to do is to
> scan articles and grab every single word
> used in an article to the keyword table
> any idea how to do that
> --

Vague question, and I suspect that there is a much better way to do what you
are trying to do, but since you didn't elaborate, here goes:

<?php
// code here to select article_number, article_text from table

$article_number=$row['article_number'];
$article_words=explode($row['article_text']);
foreach($article_words as $word){
$sql="insert into keywords (article_number, keyword) values
($article_number, '$keyword')";
//code here to toss out common words ('a', 'the', etc), execute 'insert'
query, error check, whatever else
}
?>

JM

[Back to original message]