Posted by monomaniac21 on 07/13/06 13:41

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.

• Next in forum: Re: truncating an array
• Prev in forum: Re: Micro-pump is cool idea for future computer chips
• Thread view: Re: mysql selecting distinct in one collumn but retrieving all the the other cols too

[Reply to this message]