Posted on: 05/19/04 04:24am
By: pockjaw
$color = "#C0C0C0"; // this set the background color of the switched row. //get and prep array of user info $membersprep = DB_query( "SELECT * FROM gl_users WHERE uid > 2 ORDER BY username" ); //$members = DB_fetchArray($membersprep); //figure out haw many users we really have here $limit = DB_count('gl_users') - 2; $count = 1; // tell folks how popular we really are $putout .= "There are currently " . $limit . " members of the site!n"; //Load up the first of the display $putout .= ""; //create our header row $putout .= "n"; $putout .= "<B>Name</b>n"; $putout .= "<B>Home Page</b>n"; $putout .= "<B>Join Date</b>n"; $putout .= "n"; //start spewing out information and switching the bkgrnd color $switch = false; while($count $membersout = DB_fetcharray($membersprep); switch ( $switch ) { case true: $switch = false; // alternating color $putout .= "n"; break; default: $switch = true; // default, no back color $putout .= "n"; } // switch $putout .= "<a /> $putout .= $membersout['uid'] . "">" . $membersout['username'] . "</a>"; if ($membersout['photo']!='' and $membersout['username'] != 'NULL'){ $putout .= "<br>"; }else{ $putout .= "<br>No Photo"; } $putout .= "n"; if ($membersout['homepage'] != '' and $membersout['username'] != 'NULL') { $putout .= "<a href="">" . $membersout['homepage'] . "</a>n"; }else{ $putout .= "No Homepage."; } $putout .= "" . $membersout['regdate'] . "n"; $putout .= "n"; $count++; } // while //close out the table $putout .= ""; return $putout;