mysql selecting distinct in one collumn but retrieving all the the other cols too

[monomaniac21]

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

[monomaniac21]

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

[flamer die.spam]

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.

[monomaniac21]

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 di******@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.

[Jerry Stuckle]

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 di******@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.
js*******@attglobal.net
==================