Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- Ordering column with negative and positive decimal numbers in MySQL


rocknbil - 3:52 pm on Jun 1, 2012 (gmt 0)


Well, that is a poor database design because it robs you of the power of what mySQL can do. If you're going to store attributes associated with products, those attributes should be in joined tables, not in single strings you need to break apart with your programming.

For example . . . . [webmasterworld.com]

... and again [webmasterworld.com]

Given that, otherwise you'll have to devise some way of pulling all the fields, and in your programming breaking the data apart into arrays and sorting them by the digital element as a key. Really inefficient way to go about it.


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4459880.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com