¡@
php Programming Glossary: post_tagsCompare group of tags to find similarity/score with PHP/MySQL http://stackoverflow.com/questions/3446308/compare-group-of-tags-to-find-similarity-score-with-php-mysql that I'm currently using a 3 tables . posts id image date post_tags post_id tag_id tags id name I have searched the Internet and.. targetPost.id TOTAL TAGS IN SOURCE POST SELECT COUNT FROM post_tags WHERE post_id sourcePost.id TOTAL TAGS IN TARGET POST SELECT.. sourcePost.id TOTAL TAGS IN TARGET POST SELECT COUNT FROM post_tags WHERE post_id targetPost.id 2 AVERAGE TAGS IN SOURCE TARGET..
split keywords for post php mysql http://stackoverflow.com/questions/3928325/split-keywords-for-post-php-mysql do something like this TABLES drop table if exists post_tags create table post_tags post_id int unsigned not null auto_increment.. this TABLES drop table if exists post_tags create table post_tags post_id int unsigned not null auto_increment primary key tags_csv.. STORED PROCEDURES drop procedure if exists normalise_post_tags delimiter # create procedure normalise_post_tags proc_main begin..
|