|
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
Navigation:
[Reply to this message]
|