|
|
|||||||
 |
|
|
Thread Tools | Search this Thread |
02-18-2005, 01:06 PM
|
#1 |
|
Junior Member
Join Date: Feb 2005
Posts: 2
|
How can I have all of the emails in my database appear withou the "@domain.com"
I would like to have webpage that users can visit and see a listing of all the email addresses stored but have everthing after the "@" symbol removed to protect the email addresses from being copied. Any suggestions? Thank you.
|
|
|
|
02-18-2005, 01:49 PM
|
#2 |
|
Senior Member
Join Date: Jul 2004
Posts: 167
|
Re: How can I have all of the emails in my database appear withou the "@domain.com"
Use "gd" and display the link as a picture. For an example visit http://www.whois.sc and notice how they list the owner's email address.
|
|
|
|
|
02-18-2005, 05:47 PM
|
#3 |
|
Junior Member
Join Date: Feb 2005
Posts: 2
|
Re: How can I have all of the emails in my database appear withou the "@domain.com"
I actually need to display only the email address without the domain after the @ sign. The reason is that I have to create public reports which lists the people signing up to our newsletter but this report should only show the first part of the email addresses.
Ideally, if I can generate a web page that looks like this, it would be great: 1. markjohnson@ 2. billt@ 3. user2005@ 4. any_name@ 5. etc.. |
|
|
|
|
02-18-2005, 07:50 PM
|
#4 |
|
Senior Member
Join Date: Jul 2004
Posts: 167
|
Re: How can I have all of the emails in my database appear withou the "@domain.com"
This might help
http://us2.php.net/manual/en/function.substr.php Wait, I have some code lying around for this. Found it. SUBSTRING_INDEX(email,'@',1) But that's a MYSQL statement not a PHP statement so you have to stick that in the mysql query. |
|
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Help needed on setting up a database! | AKKI | Installation | 1 | 07-07-2005 03:53 PM |
| Command to return summary info about database | Bex | SQL syntax | 0 | 02-01-2005 04:15 AM |
| Needt to design rental database - How do I begin | Tsynergy | Database Design | 4 | 12-16-2004 03:09 AM |
| 3.3 Creating and Using a Database | Administrator | Documentation | 13 | 06-09-2004 04:56 PM |
| 1.2 Overview of the MySQL Database Management System | Administrator | Documentation | 0 | 06-07-2004 10:11 PM |
