Problem: Unable to get all results, db_query returning only one result

[anir]

Code Select Expand

$request = $smcFunc['db_query']('', '
                SELECT `id_group`,`group_name`
                FROM {db_prefix}membergroups'
            );
$result = $smcFunc['db_fetch_assoc']($request);
$smcFunc['db_free_result']($request);
print_r($result);

That is my code, I am running a query but it is returning only 1 result. I have not put any limit so it should return all results.

Using smf 2.0.11, I want to get all groups, I have included ssi.php.

[Arantor]

You only run db_fetch_assoc once, you need to keep running it to get each row, it returns false when there are no more rows.

[anir]

Oh silly me, haven't used non-mvc frameworks for a long time now so I forgot, it worked thanks a lot.

[live627]

Yeah SMF has no equivalent to fetchAll() et al. These database functions are just a (very) thin wrapper around mysqli_* or pg_* functions.