Message system problem

xiong_ster123 · 12-31-2012, 11:20 PM

Hi, I'm having an issue. I'm making a message system. Can someone please help me correct this. If you need my database prefixes, I'll give you them through private message.

This is what it currently looks like.

But I want it to look like this.

This is my code.

Redcoder · 01-01-2013, 08:18 PM

I don't see anything. Do check your thread to add what you intended.

>ssp-cdr< · 01-01-2013, 09:04 PM

Those images are attachments, for some reason they aren't working.

xiong_ster123 · 01-04-2013, 02:33 AM

Sorry, some reason it wasn't working, but here are the images. If it's something to do with updating selections, please let me know because I want the messages to update. When I tested it, the number count just stays at 0.

This is my current code for it.

This is what it currently looks like.

And this is what I want it to look like.

hinch · 01-04-2013, 09:27 AM

try changing $UnreadMail=mysql_num_rows($UnreadMail);

to $unreadcount = mysql_num_rows($UnreadMail);

though thats assuming your db class works like that. does the db class not have something like $database->countOf($q);?

xiong_ster123 · 01-04-2013, 10:17 AM

Quote:

Originally Posted by hinch

try changing $UnreadMail=mysql_num_rows($UnreadMail);

to $unreadcount = mysql_num_rows($UnreadMail);

though thats assuming your db class works like that. does the db class not have something like $database->countOf($q);?

No sorry, your code just calls the user's ID. Not updating the message count.

-_- I feel silly. I found the answer. The reason why it wasn't updating was because recieved = 'unread'"; wasn't updating it so I changed it to recieved = '0'"; and it worked. Thanks for the help anyways.