stock RetrieveID(const name[])
{
    new str[128];
    format(str, 128, "SELECT `playerID` FROM `pAccounts` WHERE `playerName` = '%s'", name);
    mysql_query(str);
    mysql_store_result(); // Store the result

    new resultID = -1;
    if(mysql_num_rows())
    {
        resultID = mysql_fetch_int();
    }
    mysql_free_result(); // Free the result
    return resultID;
}

// Somewhere ( of course, the database connection is established )
printf("%d", RetrieveID("MyName"));