Unique rows from MySQL DB??

[Anon]

How do I get unique rows from a MySQL DB??

I have a simple search engine and I am having trouble getting the unique rows for a submition form.

Please help!

[gyoung]

Is this just an SQL problem?

You probably need a GROUP BY query:

SELECT col1, col2, count(*)
FROM myTable
WHERE myCondition
GROUP BY col1, col2
ORDER BY col1, col2

[[deleted]]

What exactly are you trying to do?

[Anon]

This is what im trying to do:

Ive got a table called "links" with columns: "id", "category", "subcategory", "sitename" and "url".

Now I want to make a list of categories on a page by php wrather than having to wright the categories by html. How do I retrieve the values from the column "categories" and extract the unique values so that it gives an accurate list or index for the site.

Unfortunately Im still new at this and I desparately need your help???

[[deleted]]

You cannot get 'unique' categories, because the category is identified by the 'id'.

If you had two categories named 'bla' like this:
ID Category
1 bla
2 doodie
3 bla

then which of the two 'bla' categories should you show? if you show the first, people will never ever get to the other one.

[Anon]

Hi vincent

well actually all I need is a list of avalable categories and I will create custom links for each of them.