[PHP-DB] Select distinct field won't return distinct value

I want select distinct field and return value of that field, but I have problem which is: select distinct returns duplicate value. eg, I wan select distinct customer name and id from the customer table. one customer may have different cus_ids since cus_ids are auto increment and depend on the

Re: [PHP-DB] Select distinct field won't return distinct value

Perhaps you should fix your data model... but with your current set up, try: select cus_name, cus_id from customers group by cus_name order by cus_name asc -Brad Mohamed Yusuf wrote: I want select distinct field and return value of that field, but I have problem which is: select distinct

Re: [PHP-DB] Select distinct field won't return distinct value

Correct me if I'm wrong, but it sounds like you have something like this: 123 Joe 124 Joe 125 Sue 126 John 127 Joe 128 Frank 129 Sue And you want to output something like: Joe 123, 124, 127 Sue 125, 129 John 126 Frank 128 But what you're getting is: Joe 123 Joe 124 ..etc You have

Re: [PHP-DB] Select distinct field won't return distinct value

I thank you all. problem solved using two queries as TQ mentioned. On 6/6/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Correct me if I'm wrong, but it sounds like you have something like this: 123 Joe 124 Joe 125 Sue 126 John 127 Joe 128 Frank 129 Sue And you want to output

RE: [PHP-DB] Select distinct field won't return distinct value

I'm just learning MySQL so don't know all the syntax. There is a LIST function in Sybase Adaptive Server Anywhere which would do that. Is there an equivalent function in MySQL? Query: SELECT distinct niin, list(serial_number) FROM fmds.maintenance_equipment group by niin order by niin Output:

Re: [PHP-DB] Select distinct field won't return distinct value

Blanton, Bob wrote: I'm just learning MySQL so don't know all the syntax. There is a LIST function in Sybase Adaptive Server Anywhere which would do that. Is there an equivalent function in MySQL? Query: SELECT distinct niin, list(serial_number) FROM fmds.maintenance_equipment group by niin

RE: [PHP-DB] Select distinct field won't return distinct value

It is a Sybase vendor function but I was wondering if mysql had something comparable. I don't see anything in the manual. Maybe the subquery is the only way to go. -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 07, 2006 8:50 AM To: Blanton, Bob Cc:

[PHP-DB] 【身体契約】

【身体契約】→　再度貴方の生活をサポートします！！！ 　今まで似たようなメールも有ったかも知れませんが、ご利用する 前に規約の確認は重要です。当番組は契約希望者に十分ご理解を頂 く為、登録費用・年会費・契約紹介費などを全額免除と致しまして、 大変好評を得ております。契約宣伝拡大の為、貴方をご紹介させて 頂きます。 【身体契約】とは？ 『貴方の体を○金で買いたい・・・』と希望している女性と直接交渉 して頂き、女性の要望を満たせると契約金額をゲットする方法であ る。当番組は無料で契約仲介を行っております。男性から費用を一 切頂いておりませんので、ご安心下さい。