A loop issue

[Shadowing]

Im trying to search through the read column and see if any of the rows are read

I echo $mail and it shows all the rows for the user. So im grabing the ones I want but now i dont know how to search through what I selected. Or is there a simplier way of having SQL do what im trying to do?

 

 <?php   	
   			$query = "SELECT `read` FROM pm WHERE id='".mysql_real_escape_string($_SESSION['user_id'])."'"; 
		$results = mysql_query($query) or die(mysql_error());								
	while($row = mysql_fetch_assoc($results)) { 	 
	    
		$mail = $row['read'];
}
	// checks if user has unread mail or not
if ($mail == "unread") {    
    
    
    echo '<td><b><a href="inbox.php?inbox=1">Messages</a></b></td><td id="diamond">♦</td>';
    
} else {     
    
    echo '<td><a href="inbox.php?inbox=1">Messages</a></td>';
    
}    

?> 

[requinix]

SELECT 1 FROM pm WHERE id = user ID AND read = "unread" LIMIT 1

If you get any rows back at all then there is at least one unread message.

[Shadowing]

i dont know what I was thinking lol. I dont even need to do a loop for this I just need another WHERE

 

 <?php $query = "SELECT `read` FROM pm WHERE `read` = 'unread' AND id='".mysql_real_escape_string($_SESSION['user_id'])."' "; ?> 

[Shadowing]

thanks for the responce requinix

figured it out right before you posted