$result = dbquery("SELECT * FROM ".$db_prefix."user_groups");
 
if (dbrows($result) != 0) {
while ($data = dbarray($result)) {
echo $data['group_name']." [".(dbcount("(user_id)", "users", " user_groups LIKE '%.".$data['group_id']."' OR user_groups LIKE '%.".$data['group_id'].".%'"))."]";
}
} else {
echo "nera grupiu";
}
Parsed in 0.022 seconds, using GeSHi 1.0.8.10

if (!isset($gid) || !isNum($gid)) fallback("index.php");
 
$result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_groups LIKE '%.$gid' OR user_groups LIKE '%.$gid.%'");
 
if (dbrows($result) != 0) {
while ($data = dbarray($result)) {
echo $data['user_name']."";
}
} else {
echo "nera nariu";
}
Parsed in 0.028 seconds, using GeSHi 1.0.8.10