Messages db

<?php
$query=mysql_query("SELECT inbox FROM messages WHERE inbox = '".$_SESSION['login']."'");
$aantal =mysql_num_rows($query);
echo "<font color='#FFFFFF' size='2' face='Comic Sans MS'>Berichten:</font> ".$aantal."<br>";
?>

<?php
$query=mysql_query("SELECT inbox FROM messages WHERE inbox = '".$_SESSION['login']."'");
$aantal =mysql_num_rows($query);
echo "<font color='#FFFFFF' size='2' face='Comic Sans MS'>Berichten:</font> ".$aantal."<br>";
?>

$query=mysql_query("SELECT inbox FROM messages WHERE inbox = '".$_SESSION['login']."' AND read = 0");

$query=mysql_query("SELECT inbox FROM messages WHERE inbox = '".$_SESSION['login']."' AND read = 0");

-- 
-- Tabel structuur voor tabel `messages`
-- 

CREATE TABLE `messages` (
  `id` int(4) NOT NULL auto_increment,
  `from` varchar(16) NOT NULL default '',
  `to` varchar(16) NOT NULL default '',
  `subject` varchar(50) NOT NULL default '',
  `message` text NOT NULL,
  `time` datetime NOT NULL default '0000-00-00 00:00:00',
  `read` int(1) NOT NULL default '0',
  `inbox` int(1) NOT NULL default '0',
  `save` int(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;

-- 
-- Gegevens worden uitgevoerd voor tabel `messages`
-- 

-- 
-- Tabel structuur voor tabel `messages`
-- 
 
CREATE TABLE `messages` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `from` varchar(16) NOT NULL DEFAULT '',
  `to` varchar(16) NOT NULL DEFAULT '',
  `subject` varchar(50) NOT NULL DEFAULT '',
  `message` text NOT NULL,
  `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `read` int(1) NOT NULL DEFAULT '0',
  `inbox` int(1) NOT NULL DEFAULT '0',
  `save` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=40 DEFAULT CHARSET=latin1 AUTO_INCREMENT=40 ;
 
-- 
-- Gegevens worden uitgevoerd voor tabel `messages`
--

//Query voor tellen ongelezen berichten
$countrs = mysql_query("SELECT COUNT(id) AS aantal FROM messages WHERE read=0") or die ("Error counting unread messages: " . mysql_error());
while ($countarr = mysql_fetch_assoc($countrs)){
$aantal = $countarr["aantal"];
}

//Query voor tonen ongelezen berichten
$mesrs = mysql_query("SELECT from, subject FROM messages WHERE read=0 ORDER BY id DESC") or die ("Error while retrieving unread messages: ". mysql_error());
while ($mesarr = mysql_fetch_assoc($mesrs)){
echo "<b>". $mesarr["from"]."</b> ";
echo $messarr["subject"];
}

//Query voor tellen ongelezen berichten
$countrs = mysql_query("SELECT COUNT(id) AS aantal FROM messages WHERE read=0") or die ("Error counting unread messages: " . mysql_error());
while ($countarr = mysql_fetch_assoc($countrs)){
$aantal = $countarr["aantal"];
}
 
//Query voor tonen ongelezen berichten
$mesrs = mysql_query("SELECT from, subject FROM messages WHERE read=0 ORDER BY id DESC") or die ("Error while retrieving unread messages: ". mysql_error());
while ($mesarr = mysql_fetch_assoc($mesrs)){
echo "<b>". $mesarr["from"]."</b> ";
echo $messarr["subject"];
}