Why is it showing only 1 entry?

Question

PHP

function Wo_GetPromotedPost() {
    global $wo, $sqlConnect;
    $year           = date("Y");
    $type_table     = T_POSTS;
    $logged_user_id = Wo_Secure($wo['user']['user_id']);
    $query_one      = mysqli_query($sqlConnect, "SELECT `id` FROM {$type_table} WHERE `boosted` = '1' AND `user_id` NOT IN (SELECT `blocked` FROM " . T_BLOCKS . " WHERE `blocker` = '{$logged_user_id}') AND `user_id` NOT IN (SELECT `blocker` FROM " . T_BLOCKS . " WHERE `blocked` = '{$logged_user_id}') ORDER BY RAND() LIMIT 1");
    $fetched_data   = mysqli_fetch_assoc($query_one);
    if (count($fetched_data) > 0) {
        $post = Wo_PostData($fetched_data['id']);
        if (is_array($post)) {
            return $post;
        }
    } else {
        return array();
    }
}

Why is only 1 record displayed when the page is refreshed, it changes, how to make it select all records at once

Answer 1

You stand LIMIT 1and therefore one entry

Answer 2

mysqli_fetch_assoc returns a single row of the query result as an associative array.
The next time this function is called, it will return the next line of the query result.
If there are no more lines as a result, the function will return false;
As a result, you need to call this function in a loop.

$query_result  = mysqli_query($sqlConnect, "select ...");
while($row = mysqli_fetch_assoc($query_result)){
    //...
}