patelp7 Posted March 25, 2007 Share Posted March 25, 2007 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']; } ?> Quote Link to comment Share on other sites More sharing options...
Hell Toupee Posted March 25, 2007 Share Posted March 25, 2007 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"); } Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.