Returning unique results

[Dixsta]

Hi, thanks for reading. Basically what I want to know is, I have a database full products, with their own ids, size is denoted within the id, and is appended to the end, so, 12345M 12345L, 12345XL etc., now not all products come in multiple sizes so they'd just be called 12345, but what i want to know is when display the results is there any way i can concatenate the products that have multiple sizes so instead of displaying them all, I just show say the smallest size? I thought there may be an SQL query that could help otherwise I'm not sure how I could do it because they're mixed in with other products that don't have multiple sizes.

 

Thank you for all your help.

[Bricktop]

Hi Dixsta,

 

You would need to perform a DISTINCT MySQL query with an ORDER BY.

 

Do you have some current query code you can post?  Otherwise the below example should show what you need to do:

 

SELECT DISTINCT product FROM table ORDER BY price LIMIT 1

 

Or you could use the MIN operator and do:

 

SELECT DISTINCT product, min(price) FROM table

 

Hope this helps.

[Dixsta]

SELECT * FROM product WHERE Type = '$type' ORDER BY Stock DESC $limit
// $limit is a variable used for pagination, $type just relates to a product of a certain type

 

I hope that's of some use to you and for example that may return products with the id:

 

12345S

12345M

12345L

12346

12347

12348L

12348XL

12349

12350M

12350XL

 

and i want to be left with say

 

12345S

12346

12347

12348L

12349

12350M

 

Thanks for the help.

[Bricktop]

Hi Dixsta,

 

What rows does the "product" table contain?

 

i.e.:

 

id

size

product

description

price

 

etc.

[Dixsta]

Id, stock, name, type, notes, weight

 

Hope that helps.

[sasa]

try

SELECT * FROM product WHERE Type = '$type' GROUP BY LEFT(Stock, 5) ORDER BY Stock DESC $limit