eaglelegend Posted May 14, 2008 Share Posted May 14, 2008 I was thinking instead if deleting my mail straight off my system, when mail etc. are deleted, they are moved to a "deleted" table, now how do I move a message say, when user clicks delete, it moves too that table, and as far as the user knows its deleted, however, staff are allowed to see that message so then if anything fishy is going on, staff can spot it quickly and efficiantly! Quote Link to comment Share on other sites More sharing options...
Jeremysr Posted May 14, 2008 Share Posted May 14, 2008 Maybe make a column called `deleted` which is changed to 1 when you delete it. Then when you display messages to users make your query like this: "SELECT * FROM mail WHERE NOT deleted". But for staff show the deleted ones as well. Quote Link to comment Share on other sites More sharing options...
eaglelegend Posted May 14, 2008 Author Share Posted May 14, 2008 Thanks mate, Maybe that will work, heh. lets hope so. if I remember what you said by then heh!. night Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.