RE: [PHP-DB] Multiple Entry

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 smasiello@synacor.com -----Original Message----- From: Sharif Islam [mailto:mislam@students.uiuc.edu] Sent: Wednesday, August 01, 2001 12:40 PM To: John Pickett Cc: php-db@lists.php.net 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" <mislam@students.uiuc.edu> > To: <php-db@lists.php.net> > 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: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net