hab für mein "punktesystem" ne kleine rangliste gemacht aber jetzt wollt ich erreich das nur user ab status member angezeigt werden... aber wie?
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 | <?php defined ( 'main' ) or die ( 'no direct access' ); $class = 'Cnorm' ; $class = ( $class == 'Cmite' ? 'Cnorm' : 'Cmite' ); echo '<table width= "100%" ><tr> <td><table width= "100%" border= "0" cellspacing= "0" cellpadding= "0" > <tr> <td width= "80%" >Platz / Username </td> <td width= "20%" >Punkte</td> </tr> </table></td> </tr><tr><td>'; $erg = db_query( "SELECT id, name, points FROM prefix_user ORDER BY points DESC" ); $i = 0; echo '<table class="' . $class . '" border="1" style="border-style:none; border-color:#999999;" width="100%">' ; while ( $row = db_fetch_object( $erg ) ) { $i ++; echo '<tr><td width="80%">' . $i . '. <a href="index.php?user-details-' . $row ->id. '">' . $row ->name. '</a></td><td>(' . $row ->points. ')</td></tr>' ; } echo '</table></td></tr></table>' ; ?> |