I have a MySQL database which I use to populate a table in my website. One of the columns in the table is populated with an email address from the database. What I wish to do is allow my users to click the email address in the table and send an email to the address. Currently users copy and paste the email into their email client and send it. Is there a way to format the columns cells as email addresses?
Thanks in advance…
Have you tried to change the format?
I have tried many things. At this point, I have no idea. When ypu say change format? Are you referring to the cell, its content or the database table?
I mean, make the email a mailto anchor element.
is there code that will work when the data is read from the database into the cell? I have tried many different code lines to no avail. If I code the individual to a mailto after the data is read in it will work. This is just not the way to do this. Especially if you have two hundred plus users.I would think there is a way that as the email address is read in, using a php statement, the data becomes usable to the user. The user can then just click the email to send. Plus this will save me a bunch of time…
I’m not following your verbiage.
I would think there is a way that as the email address is read in, using a php statement, the data becomes usable to the user.Read in from where?
When you output the email address, you add the markup to make it a mailto link.
If I code the individual to a mailto after the data is read in it will work. This is just not the way to do this.Not the way to do what? I have know idea what you are attempting. How are you coding an individual, but not to the entire dataset?
How about posting your code attempt. What your asking is not complicated at all.
I understand what you are saying. Code the mailto using the email address when it is read from the database and placed into the datasheet or table. Do you have an example I could use? I have searched everywhere to no avail. The database item is ‘email’ . The data is stored in the database in email format as [email protected] etc… Believe me when I say, I am not a PHP guru. Really just started with PHP in the past two months. Any help is greatly appreciated.
Post your attempt.