You must create an extra field in your database to
store the domain.
Use the explode() to seperate the domain from ...@
(array explode (string separator, string string [, int
limit])
Returns an array of strings, each of which is a
substring of string formed by splitting it on
boundaries
formed by the string separator. If limit is set, the
returned array will contain a maximum of
limit elements with the last element containing the
whole rest of string. If an empty string ("") is
used as the separator argument, then explode() will
return FALSE. If separator contains a value
that is not contained in the string argument,
thenexplode() will return the string argument.
Note: The limit parameter was added in PHP 4.0.1
Example 1. explode() example
$pizza = "piece1 piece2 piece3 piece4 piece5 piece6";
$pieces = explode(" ", $pizza);
)Form PHP manual
Cheers
--- Carlos Fernando Scheidecker Antunes
<[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: > Hello all,
>
> I've got an e-mail database of our subscribers and I
> would like to have a
> SQL statement do select DISTINCT domains.
>
> Meaning, I want to know all domains. I whish I could
> query it so that it
> would show me just once each domain, or everything
> that is after the @ sign.
>
> Does anyone knows how to query it?
>
> The e-mail field has 50 chars long. Each user
> (whatever is before the @) has
> a different lenght off course. So I need to list
> just once each domain.
>
> Any ideas or suggestions?
>
> Thank you in advance,
>
> C.F.
____________________________________________________________
Do You Yahoo!?
&Agr;&pgr;&ogr;&kgr;&tgr;&eeacgr;&sgr;&tgr;&egr; &tgr;&eegr; &dgr;&ohgr;&rgr;&egr;&aacgr;&ngr; @yahoo.gr &dgr;&igr;&egr;&uacgr;&thgr;&ugr;&ngr;&sgr;&eegr; &sgr;&agr;&sfgr; &sgr;&tgr;&ogr; http://www.otenet.gr
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
