how would i count

[zhshero]

hey i'm just woundering how i would go abouts on echoing unread messages sent to a user

i want to beable to see how many unread messages i have

[rwwd]

Some code that you have would help, show us what you have first, then we can help..

 

Rw

[zhshero]

i don't really have much of a code, half way of doing so i started thinking this can't be right and now i'm unsure where to even start

 

$sql = mysql_query("SELECT count(message_id) FROM messages WHERE MATCH(to_user='$userfinal', message_read)");

$total = mysql_fetch_array($sql);
$num = $total[0];

echo $num; 

[litebearer]

Please show the structure of you database - do you have a field to indicate if a message is read or unread?

[zhshero]

message_id 	from_user 	to_user 	user_photo 	message_title 	message_contents 	message_read 	message_date

[trq]

Seriously, can you please change that avatar? Pictures of half naked kids aren't exactly what I'm expecting on a developers forum.

[zhshero]

sorry, there i changed it

[zhshero]

Nvm i got it XD

$sql = mysql_query("SELECT count(message_id) 
FROM messages 
WHERE to_user='$userfinal' AND message_read='1'");

$total = mysql_fetch_array($sql);
$num = $total[0];

echo $num;