MYSQL query trouble

[adamlacombe]

I want to be able to have some text display when someone has new mail.

So I tried this:

<?php
$m=mysql_query("SELECT status from pm where `to`='{$_SESSION['username']}'") or die(mysql_error());
$mm=mysql_fetch_array($m);
$unreadmail=$mm[status];
?>

Then:

<?php
if($unreadmail == 0){
echo "<a href='index.php?action=messages' style='color:red;'>Unread Mail</a><br />";
}
?>

 

oh and when status=0 its unread, 1 is read

 

Any ideas on why this wont work?

[kickstart]

Hi

 

Missing quotes?

 

$unreadmail=$mm['status'];

 

All the best

 

Keith

[adamlacombe]

nope thats not it..

hmm..

Any other ideas?

 

Should I be using mysql_fetch_array or something else, maybe?

[kickstart]

Hi

 

Does the pm table contain one row per pm? If so, if they had more than one pm wouldn't it bring back the status of a random one?

 

<?php

$m=mysql_query("SELECT MIN(status) FROM pm WHERE `to`='".$_SESSION['username']."'") or die(mysql_error());

$mm=mysql_fetch_array($m);

$unreadmail=$mm['status'];

?>

 

All the best

 

Keith