unread topics

[patelp7]

I have manage to output a list of bulletins. But I have to be able to indicate ones which have not been read, by highlighting unread bulletins in a different colour. I have no idea how to do this, or what topic to search for on the net.  Can someone please help?

 

<?
session_start();
require ("db.php.inc");
//require ("ViewBulletin.inc");



$query = "select B.Subject, B.Datecreated From Bulletin B, Relative R 
          WHERE 
	  B.Adminusername = R.Adminusername 
	  AND R.Username = '".$_SESSION['Username']."' 
	  ORDER BY Datecreated DESC";

$result = mysql_query ($query); 

// Run the query.
$numofsubs = mysql_num_rows($result);

if ($numofsubs > 0) { // If it ran OK, display the records.
echo "<p>There are currently $numofsubs bulletins published.</p>\n";


// Fetch and print all the records.

while ($numofsubs = mysql_fetch_array($result)) 
{


	//echo <td align="left"><a href="viewspecificbull.php?id=' . $numofsubs['Subject'] . '">View</td></br>
	echo ('<td align="left">' . $numofsubs['Datecreated'] . '</td>
	       <td align="left">' . $numofsubs['Subject'] . '</td>
			<td align=left><a href="viewspecificbull_NextWay.php?id=' . $numofsubs['Subject'] . '">View Subject: </a></td></br>'); 
		    

}

//$_SESSION['Subject']= $numofsubs['Subject'];
}
?>

[Hell Toupee]

Have a boolean field in the table which indicates whether or not the bulletin has been read.

 

Then later on the line where you display the subject of the bulletin have an ifstatement like:

 

if ($row[booleanfield]=true){

echo("bulletin subject with red color");

}else{

echo("bulletin subject with normal color");

}