'; echo 'Leden: '.$iLeden.'
'; $sOn_leden = mysql_query("SELECT * FROM online WHERE memberID != ''") or die("lidn:".mysql_error()); $aLeden_id = mysql_fetch_array($sOn_leden); $geg_name = mysql_query("SELECT * FROM leden WHERE id = '".$aLeden_id['memberID']."'") or die("geg_name:".mysql_error()); while($aRow = mysql_fetch_array($geg_name)) { echo $aRow['gebruikersnaam']; } ?> CREATE TABLE `online` ( `userIP` varchar(15) NOT NULL default '', `memberID` smallint(6) unsigned default NULL, `location` tinytext, `logTime` timestamp(14) NOT NULL, PRIMARY KEY (`userIP`) ) TYPE=MyISAM;