2 queries in 1 (Opgelost)

CREATE TABLE `pagelog2` (
  `id` int(5) unsigned NOT NULL auto_increment,
  `ip` varchar(50) NOT NULL default '',
  `mid` int(10) NOT NULL default '0',
  `locatie` varchar(50) NOT NULL default '',
  `tijddatum` decimal(20,0) default NULL,
  `loggedin` int(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6568 DEFAULT CHARSET=latin1;

CREATE TABLE `pagelog2` (
  `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `ip` varchar(50) NOT NULL DEFAULT '',
  `mid` int(10) NOT NULL DEFAULT '0',
  `locatie` varchar(50) NOT NULL DEFAULT '',
  `tijddatum` decimal(20,0) DEFAULT NULL,
  `loggedin` int(1) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=6568 DEFAULT CHARSET=latin1;

<?php
$query = mysql_query("SELECT *,MAX(tijddatum) AS nTijdDatum FROM `pagelog2` WHERE `loggedin`='0' GROUP BY `ip` ORDER BY `nTijdDatum` DESC") or die(mysql_error());

while($fetch = mysql_fetch_assoc($query)) {
	$ip = $fetch['ip'];
						
	$fetch3 = mysql_fetch_assoc(mysql_query("SELECT * FROM `pagelog2` WHERE `ip`='" . $ip . "' AND `loggedin`='0' AND `tijddatum`='" . $fetch['nTijdDatum'] . "'"));
							
	//En dan haal ik alle data uit $fetch3
}
?>

<?php
$query = mysql_query("SELECT *,MAX(tijddatum) AS nTijdDatum FROM `pagelog2` WHERE `loggedin`='0' GROUP BY `ip` ORDER BY `nTijdDatum` DESC") or die(mysql_error());
 
while($fetch = mysql_fetch_assoc($query)) {
	$ip = $fetch['ip'];
 
	$fetch3 = mysql_fetch_assoc(mysql_query("SELECT * FROM `pagelog2` WHERE `ip`='" . $ip . "' AND `loggedin`='0' AND `tijddatum`='" . $fetch['nTijdDatum'] . "'"));
 
	//En dan haal ik alle data uit $fetch3
}
?>

ORDER BY id DESC

ORDER BY id DESC