unread messages in header

[Adam LaCombe]

This code will show users if they have unread messages in the header of your site.

heres the code:

Code: [Select]

<?
$w = $db->query("SELECT * FROM dd_messages WHERE to_userid='{$userid}' LIMIT 0,1");
while($iw = $db->fetch_row($w)){
if($iw['status'] == 0){
echo'You have <a style="color:green; font-weight:bold; font-size:15" href="'.$domain.'/index.php?action=messages">Unread Message(s)</a>';
}}
?>

You can put it anywhere in just about any file.
If you want it in the header just open up the templates/default dictionary and open the header.php file.