new username[MAX_PLAYER_NAME+1];mysql_query("SELECT `UserName` FROM `users` WHERE `SquadID` = `1`");mysql_store_result();while(mysql_retrieve_row()){ mysql_fetch_field_row(username, "Username"); // etc..}mysql_free_result();