Jump to content

Sorting MYSQL Results


poolhustler86

Recommended Posts

Hey Everyone...

I have a question reguarding how to sort mysql results from a table.

I have a table with a column (varchar) named prod_size_color...

example data...

80mm x 80mm x 11.5mm - White
115mm x 80mm x 11.5mm - White

Everytime i sort it by the prod_size_colour the 115mm x 80mm x 11.5mm - White appears first... the only way to stop that happening is to place a 0 infront of 80mm x 80mm x 11.5mm - White...

Anyway I can sort it without placing 0 infront?
Link to comment
https://forums.phpfreaks.com/topic/34225-sorting-mysql-results/
Share on other sites

If all records in that table have three dimension characteristics, Then create three columns in the table for each size parameter and only put the numerical value (i.e. not the "MM") in those fields. You could then easily do a numerical sort on the first value, thent he 2nd and the third. You wouldn't need the current column with all three values as you could simply concatenate the three vales with the "mm" when youdisplay them.
Link to comment
https://forums.phpfreaks.com/topic/34225-sorting-mysql-results/#findComment-161283
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.