Hi DN.
If there is a quisker solution is OK to me. But i dont
know it. I believe that when a user (anybody) inserts
data in a database, you can sereate the information
you want that time. Then you just call the results
from the table (you have them ready) and dont ask the
server to work for it.
If you know an other solution, i'll be happy to learn
it.
Cheeres
--- DL Neil <[EMAIL PROTECTED]> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: >
Nick,
> Understood - but did Carlos say that he is using
> PHP, and why use PHP when a
> more efficient/quicker MySQL solution is available?
> =dn
>
> ----- Original Message -----
> From: "nick gatsis" <[EMAIL PROTECTED]>
> To: "DL Neil" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Monday, August 12, 2002 9:06 AM
> Subject: Re: How to separate different domains on an
> e-mail database
>
>
> > Its a PHP function my friend. I'm using 3,23...
> >
> > --- DL Neil <[EMAIL PROTECTED]>
> &eacgr;&ggr;&rgr;&agr;&psgr;&egr;: >
> > Nick,
> > > Explode: which version of the MySQL manual are
> you
> > > using?
> > > =dn
> > >
> > > ----- Original Message -----
> > > From: "nick gatsis" <[EMAIL PROTECTED]>
> > > To: "Carlos Fernando Scheidecker Antunes"
> > > <[EMAIL PROTECTED]>
> > > Cc: <[EMAIL PROTECTED]>
> > > Sent: Friday, August 09, 2002 2:33 PM
> > > Subject: Re: How to separate different domains
> on an
> > > e-mail database
> > >
> > >
> > > > 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
> > > >
> > > >
> > >
> >
> >
>
____________________________________________________________
> > 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
> >
>
____________________________________________________________
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
