PHP db_DoFetchFirst Exemples

Exemple #1

Fichier : legacy_user.php Projet : LastResortGames/ludumdare

function legacy_GetUserWithInfo($id)
{
    db_Connect();
    return db_DoFetchFirst("SELECT id," . MYSQL_ISO_FORMAT('timestamp') . ",hash,bonus_votes,num_events,gravatar\n\t\tFROM " . CMW_TABLE_LEGACY_USER . " WHERE id=? LIMIT 1;", $id);
}

Exemple #2

Fichier : theme.php Projet : LastResortGames/ludumdare

function theme_GetRandom($node)
{
    return db_DoFetchFirst("SELECT id,theme FROM " . CMW_TABLE_THEME_IDEA . " \n\t\tWHERE node=? AND parent=0\n\t\tORDER BY rand() LIMIT 1", $node);
}