function kwresearch_update_keyword_page_counts in Keyword Research 6

Same name and namespace in other branches

1. 7 kwresearch.module \kwresearch_update_keyword_page_counts()

Updates the page_count field in site keyword table

Parameters

int $kid - id of keyword:

2 calls to kwresearch_update_keyword_page_counts()

kwresearch_delete_page_keywords_by_page in ./kwresearch.module

Deletes all the page keyword for a given page

kwresearch_save_page_keyword in ./kwresearch.module

Saves a page keyword. Links a site keyword to a node/page

File

./kwresearch.module, line 609

Code

function kwresearch_update_keyword_page_counts($kid) {
  $sql = '
    SELECT COUNT(*)
    FROM {kwresearch_page_keyword}
    WHERE kid = %d
  ';
  $count = db_result(db_query($sql, $kid));
  $sql = '
    UPDATE {kwresearch_keyword}
    SET page_count = %d
    WHERE kid = %d
  ';
  db_query($sql, $count, $kid);
  return $count;
}