> How about just fixing this so it'll be easier in the future? You should
> have a separate table where each "keyword" is in it's own row, with or
> without duplicates (depends if you want a "count" of how often the
> keyword is used), and an ID relating back to the "article" or whatever
> you have.
I think, that the problem with duplicates can be solved by using "distinct"
parametr in SQL-query whitch count each keyword only once, however it is
there ten times...
Pavel
>
> The process of creating the table and creating the array are about the
> same. The table will give you more flexibility, though, when the client
> starts asking for more "stats".
>
> To use the array method, like you originally asked:
>
> $var = array();
> $query = "SELECT keyword FROM table";
> $rs = mysql_query($query);
> while($row = mysql_fetch_assoc($rs))
> {
> $ar = explode(' ',$row['keyword']);
> array_merge($var,$ar);
> }
> $var = array_unique($var);
> $final_array = sort($var);
>
> To INSERT everything into a second table:
>
> $query = "SELECT keyword FROM table";
> $rs = mysql_query($query);
> while($row = mysql_fetch_assoc($rs))
> {
> $keywords = explode(' ',$row['keyword']);
> $insert_string = "'" . implode("','",$keywords) . "'";
> //assumes no ' characters in $keywords
> $query = "INSERT INTO keywords_table VALUES ($insert_string)";
> $rs2 = mysql_query($query);
> }
> Make the keywords column UNIQUE if you don't want duplicates, although
> it would probably be better to just leave duplicates in there and do a
> SELECT DISTINCT to remove them. Leaving them in there will allow you to
> produce more stats on which keywords are most popular, etc.
>
> ---John W. Holmes...
>
> Amazon Wishlist: http://www.amazon.com/o/registry/3BEXC84AB3A5E
>
> PHP Architect - A monthly magazine for PHP Professionals. Get your copy
> today. http://www.phparch.com/
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
