Geeklog Forums

$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;