Welcome Guest, Not a member yet? Register   Sign In
string based custom ordering in active record
#3

[eluser]tsandesh23[/eluser]
The category is a field in item table and (‘Auto & Accessories’, ‘Couch’, ‘Bed’, ‘Desk & Office’, ‘Bike & Scooter’, ‘Tools’, ‘Leisure’, ‘Iron & Wood’, ‘Cabinet’, ‘Kitchen & Accessories’, ‘Refrigerator & Appliances’, ‘Toys & Games’, ‘Chair’, ‘Table’, ‘Garden & Terrace’, ‘TV, HIFI & Computers’, ‘General Item’) are the possible values in category list. One record can contain one of above value and these are the only possible values in category field.
The problem is, the database is already designed and is live and thousands of customers are using this service. Initially, this project was built in normal php+mysql, but, our company need to change it into CI.

So, I can't change the database schema. Only thing that I should do is make the exact copy of previous code in CI and all the queries in active records. So, please help me to order these categories in above order.


Messages In This Thread
string based custom ordering in active record - by El Forum - 03-23-2013, 04:55 AM
string based custom ordering in active record - by El Forum - 03-23-2013, 06:33 AM
string based custom ordering in active record - by El Forum - 03-23-2013, 09:35 AM
string based custom ordering in active record - by El Forum - 03-23-2013, 10:02 AM
string based custom ordering in active record - by El Forum - 03-23-2013, 08:15 PM
string based custom ordering in active record - by El Forum - 03-24-2013, 04:11 AM
string based custom ordering in active record - by El Forum - 03-24-2013, 05:09 AM
string based custom ordering in active record - by El Forum - 03-24-2013, 07:09 AM
string based custom ordering in active record - by El Forum - 03-27-2013, 03:04 AM



Theme © iAndrew 2016 - Forum software by © MyBB