Posted by monomaniac21 on 07/12/06 16:00

heres the query im trying (well one variant):

$result = mysql_query("SELECT name, id FROM tblproducts WHERE category
= '$category_get' & name = DISTINCT ORDER BY name ASC LIMIT 0,8");

also tried: "select distinct name, id.." to no avail...


monomaniac21 wrote:
> hi!
>
> is it possible to do the aforementioned query - selecting only distinct
> in 1 col but retrieving all other cols at the same time.
>
> regards
>
> marc

[Back to original message]