i dont want resemblance on the result -need help-

[webtuto]

hey

i have a query that look like this

 

$sql = mysql_query("select * from table where user='$cat'");

 

and on the table on the database i have names that are similar

but while using mysql_fetch_array i dont want the names to be similar on the page while posting results

 

so how can i do that ?

[pocobueno1388]

I'm not exactly sure what your wanting, but it sounds like you want to use DISTINCT

 

select *, DISTINCT(name) from table where user='$cat'

[webtuto]

yeah but when i try this

select DISTINCT * from `song` where category='$cat'

 

it gives an error bcz i want all not just a row

i want to use * not a row name

[pocobueno1388]

I think if you want to do it that way, your going to have to use GROUP BY as well.

 

SELECT DISTINCT * FROM `song` WHERE category='$cat' GROUP BY category

 

If that doesn't work, you may have to just manually type all the fields

 

SELECT DISTINCT field1, field2 FROM `song` WHERE category='$cat'