Jump to content

unread topics


patelp7

Recommended Posts

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'];
}
?>

Link to comment
https://forums.phpfreaks.com/topic/44264-unread-topics/
Share on other sites

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");

}

Link to comment
https://forums.phpfreaks.com/topic/44264-unread-topics/#findComment-215006
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.