Re: [PHP-DB] Multiple Entry

2001-08-01 Thread Miles Thompson
Try GROUP BY in the select statement: select services, machine_name from table GROUP BY services order by machine_name; I believe it should return: MS Exchange Server and BDC MAIL Microsoft Exchange for UA UAMAIL1 UAMAIL2

RE: [PHP-DB] Multiple Entry

2001-08-01 Thread Sam Masiello
nt: 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 an

Re: [PHP-DB] Multiple Entry

2001-08-01 Thread Sharif Islam
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

Re: [PHP-DB] Multiple Entry

2001-08-01 Thread John Pickett
xec/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: > > +-

[PHP-DB] Multiple Entry

2001-08-01 Thread Sharif Islam
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