New Messages Bold??

treeleaf20

If I have a table structure like: message_id, user_id, sender_id, title, subject, body, read, date

I would like new messages to be bold so when a user will click on get private messages it will display the non-read messges in bold and the already read messages non-bold. How can I do this?

Thanks.

maxpup979

cross table with userid, message id and status should do the trick

treeleaf20

If I do:

$user_id = $_GET[userid];
$query = "SELECT title, subject, body from messages, read Where user_id='$user_id'";
$result=mysql_query($query);

From that selection how would I determine which rows haven't been read and then bold those rows and also display the already messages in regular text as well.

Thanks

gufmn

treeleaf20 wrote:
If I do:
$user_id = $_GET[userid];
$query = "SELECT title, subject, body from messages, read Where user_id='$user_id'";
$result=mysql_query($query);
From that selection how would I determine which rows haven't been read and then bold those rows and also display the already messages in regular text as well.

Thanks

Does that selection give you anything besides a syntax error?

Seems to me it should be something like:
"SELECT title, subject, body, read, FROM messages WHERE user_id = '$user_id'"

Then just loop through and apply a little css:

while($row = mysql_fetch_array($result)){
    if($row['read'] == "read"){
        echo '<div class="bold">';
    }
    else {
        echo '<div class="normal">';
    }
    echo $row['subject'] . '</div>';
}

maxpup979

let me be a little more specific. I assume you have a users table. you also should have a message table with things like messageid, body, title etc. what I think is the best way to do this is to incorporate a thrid table: a cross table between users and messages that also has a status field. This way, you can use a join when you call up the message, to determine whether or not the message has been read by that user. If you try and keep this information in the message table, it is going to be nuts.

your query in this structure would be something like:

select m.title,m.body,m.messageid,x.status from messages m,crosstable x where m.messageid=x.messageid and x.user='$currentuser' and messageid='$currentmessage';