Jump to content

Archived

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

tomfmason

Simple mysql question

Recommended Posts

I am writing, for a friend, a message script that uses a database instead of sending the message via email. Now when he logs in I want him to be able to see any new messages. I plan on having a new_message field in the admin table that would be the message_id from the from the message table.

I know this is simple and I should already now how to do this but I don't....lol. My question is how would I post to the message_id to the new_message field when the message is sent?

Share this post


Link to post
Share on other sites
why dont you have a field in the original messages like message status and when someone posts a new message the status will be new, and then if they read it, read, etc, etc.....

Share this post


Link to post
Share on other sites
is that of help then?

i mean like u can have SELECT * FROM messages WHERE messages_status='NEW'

Share this post


Link to post
Share on other sites
Yes that was alot easier then what I was wanting to do. I always try to over complicate things.


Thanks

Share this post


Link to post
Share on other sites

×

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.