I don't see how you would do it unless you changed your Services field to
better associate it with the machine name.  Perhaps something like

Microsoft Exchange for UA1
Microsoft Exchange for UA2
Microsoft Exchange for UA3

Even if you do a "select distinct" on services with your table in its
current form, you will get one row, but there will be no way to associate it
with the proper machine name.

HTH

Sam Masiello
Software Quality Assurance Engineer
Synacor
(716) 853-1362 x289
[EMAIL PROTECTED]

 -----Original Message-----
From:   Sharif Islam [mailto:[EMAIL PROTECTED]]
Sent:   Wednesday, August 01, 2001 12:40 PM
To:     John Pickett
Cc:     [EMAIL PROTECTED]
Subject:        Re: [PHP-DB] Multiple Entry


Ya, I understand that. But when I want to view all services then I get
three output for Microsoft Exchange. I want only one at that time. And
click that service and I can get the machine name.


On Wed, 1 Aug 2001, John Pickett wrote:

> If I understand you correctly you might try a query like:
>
> select services from tabl where machine_name="UAMAIL3";
>
> That should only return one result based on the data you gave...
>
> My 2 
> John Pickett
> http://www.bvstudios.com/
> Co-Author:  Inside Dreamweaver 4
> http://www.amazon.com/exec/obidos/ASIN/0735710848/xtremist
>
> ----- Original Message -----
> From: "Sharif Islam" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Wednesday, August 01, 2001 10:30 AM
> Subject: [PHP-DB] Multiple Entry
>
>
> >
> > I have some data in a table like this:
> >
> > +----------------------------+--------------+
> > | services                   | machine_name |
> > +----------------------------+--------------+
> > | MS Exchange Server and BDC | MAIL         |
> > | Microsoft Exchange for UA  | UAMAIL1      |
> > | Microsoft Exchange for UA  | UAMAIL2      |
> > | Microsoft Exchange for UA  | UAMAIL3      |
> > +----------------------------+--------------+
> >
> > As you can see, there are same entry for the services column. So If
> > I to display in php :
> >
> > select services from table; then I will get three same entry.
> >
> >
> > Is there any way, I can get only one output.But somehow I have to
> > incorpate it with the other data in that column, which doesn't have
> > multiple entry. Any hint? thanks in advance.
> >
> >
> >
> >
> >
> >
> > --
> > PHP Database Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> > To contact the list administrators, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to