[SOLVED] won't count contents

[dadamssg]

im trying to display the number of new messages next to an Inbox link....heres my code

$me = $_SESSION['logname'];

$cxn = mysqli_connect($host,$user,$passwd,$dbname) or die("Couldn't connect"); 
     $sql = "SELECT * FROM Messages 
                    WHERE sentto = '$me' AND status='0'";  
     $result = mysqli_query($cxn,$sql)
               or die("Couldn't execute select query.");
 		   
     $count = mysqli_num_rows($result); 

 

and then i attempt to echo $count but its not outputting anything. the query works in phpmyadmin

 

[PFMaBiSmAd]

Have you checked that $me contains what you think it does? Echo $sql to see what it actually contains.

[dadamssg]

hey sorry, yeah i figured it out...this piece of code was in a function in a include file and i just noticed that that section wasn't inside the function i was calling on the page i was expecting results....thanks though!