Posted by Jerry Stuckle on 07/13/06 15:33

monomaniac21 wrote:
> you cant do this query:
>
> SELECT * FROM tblproducts WHERE name = DISTINCT ORDER BY date_added
> DESC, name ASC LIMIT 0,8
>
> mysql wont allow it. by distinct im referring to unique values not the
> string value equal to distinct.
>
> can anyone help me with a query that can do this?
>
>
> flamer die.spam@hotmail.com wrote:
>
>>monomaniac21 wrote:
>>
>>
>>>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
>>
>>what do you mean exactly?? you can do:
>>$result = mysql_query("SELECT * FROM tblproducts WHERE category
>> = '$category_get' & name = DISTINCT ORDER BY name ASC LIMIT 0,8");
>>
>>that will select all the fields from each row that matches your where
>>clause..
>>
>>Flamer.
>
>

Maybe you should ask MySQL questions in a group such as
comp.databases.mysql - where the MySQL gurus hang out?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

• Next in forum: Problem receiving an array with php5/soap from a gsoap server
• Prev in forum: Re: header(Location: $var) loops in IE
• Thread view: Re: mysql selecting distinct in one collumn but retrieving all the the other cols too

[Reply to this message]