[SOLVED] New mail icon

[supermerc]

Hey, i followed obsidian tutorial for a om system, with special help (thanks again obisidian)

 

And now I want a little envelope icon to show when I have a new message, so I tried something but its not working.

 

<?php
session_start();
      require("config.php");
      require("functions.php");  
	echo '<p>Welcome, '.$_SESSION['s_name'].',</p>';
	echo '<p>You are logged in as '.$_SESSION['s_username'].'.';
	echo '<p><a href="members.php">Members</a>'; 
	echo '<p><a href="inbox.php">Inbox</a>';
	$message = mysql_query("SELECT COUNT(*) FROM myPMs WHERE opened != 'y' AND to_id = '{$_SESSION['s_id']}'") or die ("My SQL Error: <br />". mysql_error());
                $msgs = mysql_fetch_array($message);

if ($msg['COUNT(*)'] > 0) {
  // News Msgs Found
  echo "<img src=\"images/envelope.gif\" /> You have {$msg['COUNT(*)']} new messages.<br />";
	}
	;
	echo '<br><a href="edit_profile.php">My Profile</a>';
	echo '<br><a href="logout.php">Logout</a></br>';
?>

 

Please help thank you

[AndyB]

Do you see a 'missing image' icon? View the generated html source. Is the image on your server in the folder you think it's in?

[supermerc]

Yes i checked path and it works

[AndyB]

And what shows in the generated HTML code?

[supermerc]

whats that?

[interpim]

whatever the script output page is...

 

right click, view source... that is your html output

[supermerc]

<p>Welcome, Alex Deslauriers,</p><p>You are logged in as supermerc.<p><a href="members.php">Members</a><p><a href="inbox.php">Inbox</a><br><a href="edit_profile.php">My Profile</a><br><a href="logout.php">Logout</a></br>

 

Thats what I get

[jeremywesselman]

Have you checked to make sure that your query is returning a result?

 

<?php
print_r($msgs);
?>

 

(might be a dumb question, but let's just be sure here)

[supermerc]

I put it at the end of my code and this is what i got

 

Array ( [0] => 2 [COUNT(*)] => 2 )

[jeremywesselman]

lol. I can't believe I didn't see it before...

 

if ($msg['COUNT(*)'] > 0) {

 

You've got a spelling error. $msg should be $msgs...

 

Jeremy

[supermerc]

Ok im officially in love with you