poolhustler86 Posted January 15, 2007 Share Posted January 15, 2007 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 - White115mm x 80mm x 11.5mm - WhiteEverytime 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 More sharing options...
Psycho Posted January 15, 2007 Share Posted January 15, 2007 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 More sharing options...
sasa Posted January 15, 2007 Share Posted January 15, 2007 try order by (prod_size_color + 0) Link to comment https://forums.phpfreaks.com/topic/34225-sorting-mysql-results/#findComment-161510 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.