Exemplos de db_QueryFetchValue em PHP

Exemplo n.º 1

Arquivo: theme_idea.php Projeto: povrazor/ludumdare

function themeIdea_CountUsers($event_id, $query_suffix = ";")
{
    return db_QueryFetchValue("SELECT count(DISTINCT user)\n\t\tFROM " . SH_TABLE_PREFIX . SH_TABLE_THEME_IDEA . " \n\t\tWHERE node=?\n\t\tLIMIT 1" . $query_suffix, $event_id);
}

Exemplo n.º 2

Arquivo: user_core.php Projeto: povrazor/ludumdare

function user_CountByNode($node, $query_suffix = ';')
{
    return db_QueryFetchValue("SELECT count(id) FROM " . SH_TABLE_PREFIX . SH_TABLE_USER . " \n\t\tWHERE node=?\n\t\tLIMIT 1" . $query_suffix, $node);
}