473,287 Members | 1,904 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,287 software developers and data experts.

Setting the 'unread' status of a message

62
Hi, there
I have a problem to set the unread msg.Well, actually i can say i know nothing about this system. What i do is i have a field in database call open
and in the send mail form i put a hidden input name =open value=N
when customer click to send the mail the value N will be put in the field open in database.

My question is how can i do it when the customer open their msg the value N will change to be Y in database,so that will let us know that mail was open ?
please help me
Thank you
Paitoon
Aug 29 '07 #1
4 1711
pbmods
5,821 Expert 4TB
Changed thread title to better describe the problem.
Aug 29 '07 #2
gregerly
192 Expert 100+
Hi, there
I have a problem to set the unread msg.Well, actually i can say i know nothing about this system. What i do is i have a field in database call open
and in the send mail form i put a hidden input name =open value=N
when customer click to send the mail the value N will be put in the field open in database.

My question is how can i do it when the customer open their msg the value N will change to be Y in database,so that will let us know that mail was open ?
please help me
Thank you
Paitoon
This should be pretty simple. If your already writing queries as It seems you are, you just need an update query on what ever page the viewer will look at the mail.

Lets say when the user clicks a link to read the message you are passing the ID of the message in the URL, so the page knows which message to open. Your query could look like this:

[PHP]//set a variable for the mail id
$mailid=$_GET['mailid'];

$sql="UPDATE myMailTable SET myMailTable.open = 'n' WHERE myMailTable.mailid = $mailid;";[/PHP]

If this isn't clear enough, post back and we'll go from there.

Greg
Aug 29 '07 #3
paitoon
62
superb :-) i got it...thank you
Aug 30 '07 #4
gregerly
192 Expert 100+
superb :-) i got it...thank you
Awesome. Glad to have helped.

Greg
Aug 30 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: pierre.basson | last post by:
Hi, I have a DataList that contains an image and 3 radio buttons. The radio buttons are used to change the status of the image i.e. Approved, Suspended and Deleted. When the form loads, I want...
1
by: PhilD | last post by:
My C#.NET console app checks a public folder every 24 hours for incoming emails. For each unread email in the folder, it copies any attachments to the network, then loads the contents of these files...
1
by: laredotornado | last post by:
Hi, I'm using PHP 4.4.4 on Apache 2 on Fedora Core 5. PHP was installed using Apache's apxs and the php library was installed to /usr/local/php. However, when I set my "error_reporting"...
8
by: Army1987 | last post by:
Is this a good way to discard unread data after scanf()? while (getchar() != '\n') ; According to the FAQ scanf always leaves the trailing newline on the input stream, so there's no risk of...
8
by: Sid | last post by:
I hope someone could help me with this. I am trying to setup a criteria to decide when to allow/not allow user to click on the check box. logically it looks simple but I am not able to...
3
by: paitoon | last post by:
I want to know how to count messge unread in inbox,And how can the message that was not read will be the read color and after read it will be the normal color as read messages? How it work and what...
1
by: RobertTheProgrammer | last post by:
Hi all, I have a perplexing problem here. I've developed some software using ASP.NET with C# in the code behind. I've been setting the "window.defaultStatus" in the code behind to send messages...
17
by: vishal1082 | last post by:
i wanna get number of unread mails from mail servers, like gmail, yahoo, msn, aim and any other email server which user gives but the problem is - i dont know HOW (lol) i tried this DLL:...
1
by: sarahaziz | last post by:
Hello Guys i am trying to implemenet something like the read/unread in the email.How can i do so by using jquery , php and mysql. What i want to do in steps: 1- When i click on a row in html table...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: marcoviolo | last post by:
Dear all, I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.