question about styles

[nexus]

I'm pretty new to vb, and I have just one question right now.. Is it possible to integrate into the styles section of the admin cp, the numbers of how many board members use each different style? I just thought this would be a really neat feature, but I have no idea how to make it work.

So when clicking styles --> modify, right next to each style listed there could be a number of people that use each of them.. Is this at all possible?

thanx in advance

[Chen]

Open style.php (in the admin folder) in a text editor, and replace this:

  while ($style=$DB_site->fetch_array($styles)) {

    echo "<tr class='".getrowbg()."'>\n<td><p>$style[title]</p></td><td><p>".

with this: (my code in red)

  while ($style=$DB_site->fetch_array($styles)) {
[color=red]    $users=$DB_site->query_first("SELECT COUNT(*) AS count FROM user WHERE styleid='$style[styleid]'");[/color]
    echo "<tr class='".getrowbg()."'>\n<td><p>$style[title] [color=red]($users[count] users)[/color]</p></td><td><p>".

[nexus]

thank you very much firefly!! works like a charm!!

[Chen]

No problem!