function kwresearch_load_site_keyword in Keyword Research 6

Same name and namespace in other branches

1. 7 kwresearch.module \kwresearch_load_site_keyword()

Loads site keyword object from databased

Parameters

int|string $key if int, treated as a kid. If str treated as a keyword phrase:

10 calls to kwresearch_load_site_keyword()

kwresearch_delete_site_keyword in ./kwresearch.module

Deletes site keyword from db

kwresearch_get_keyword in ./kwresearch.module

Returns the keyword phrase for a given kid

kwresearch_get_kid in ./kwresearch.module

Returns the kid for a given keyworld

kwresearch_keyword_pages_page in ./kwresearch.admin.inc

Generates table of pages assoicated with a keyword

kwresearch_load_page_keyword in ./kwresearch.module

Loads page keyword object from database

... See full list

File

./kwresearch.module, line 292

Code

function kwresearch_load_site_keyword($key) {
  if ($key > 0) {

    // load by kid
    $sql = '
      SELECT *
      FROM {kwresearch_keyword}
      WHERE kid = %d
    ';
    $keyword_obj = db_fetch_object(db_query($sql, $key));
  }
  else {

    // load by keyword
    $sql = '
      SELECT *
      FROM {kwresearch_keyword}
      WHERE keyword = "%s"
    ';
    $keyword_obj = db_fetch_object(db_query($sql, $key));
  }
  return $keyword_obj;
}