By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,982 Members | 1,939 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,982 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Jul 12 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Jul 12 '06 #2

P: n/a

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.

Jul 12 '06 #3

P: n/a
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.
Jul 13 '06 #4

P: n/a
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
==================
Jul 13 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.