MySQL Distinct

Anon

I have read a few threads regarding the mysql's distinct, and it seems to have some problems when used by PHP.

None the less, I am having a problem with distinct. I have a table like this:

field1 - field2

1 - 1
2 - 1
1 - 2
2 - 2

If i select all of the field2 i will return:

1
1
2
2

But i only want a distinct field 2, so it would return

1
2

But this isnt working. Here is my query

SELECT distinct(field2) FROM table

Note: i tried it also without the brackets.

Any ideas, comments?

Anon

that looks right to me... what does it return? error message? all of the results?

Anon

It will return all of the results

1
1
2
2

Besides this crappy distinct, is there a work around for this that i could do?

Anon

why not try:

SELECT field2 FROM table GROUP BY field2;

That should get you what you want 🙂

Chris King

Anon

🙁 That does not work... still printing duplicates of field2. My query was:

SELECT field2 FROM table GROUP BY field2

Any other ideas?

Anon

Sorry take back the last post, it does work, but im in a while loop when im calling the next query. So it doesnt work.. still stuck.

Bit more explination.

Im in one while loop, and for each result, im doing another query, that gets data from another table. So the group by does not. it will however work if i take the first while loop out. Any ideas to solve this now?

Anon

Why don't you use join queries based on some common field as there is a lot of over head in the way you are doing it