|
nickelmedia
|
December 31, 2012 at 9:58 pm
I’ve created categories that output to a table. They are Alphanumeric, but always start with a number. Currently, their output seems random. I’d like to order them from low to high (8U 9U 10U, etc.) Here is an example. It’s the last column of the table I’m trying to re-order http://utrip.pickorange.com/event-list/
I saw this similar post, but couldn’t figure it out as the code has changed around a bit. https://eventespresso.com/forums/2010/09/order-listing-of-categories/
I’m aware that manual sorting is on the list for future enhancements, but for now, is there a way I can accomplish this with some kind of sort()?
Thanks!
Jeff
|
|
Chris Reynolds
|
January 1, 2013 at 2:37 pm
The order is most likely by category ID, which should correspond with the order in which the categories were created. You could go and rename all your categories so they are sequential that way. The other option would be modifying the SQL query. Depending on where you are trying to make this happen would determine what template files would need to be modified.
|
|
nickelmedia
|
January 2, 2013 at 9:21 pm
I don’t think it’s SQL ID. Here is the result of my Category table.
Yet I’m still getting results like this:
I’m using the custom file template espresso_table.php to get the table. Is there any kind of JS or PHP sort I can apply to just that cell?
|
|
nickelmedia
|
January 5, 2013 at 10:05 am
Any other suggestions?
|
|
nickelmedia
|
January 5, 2013 at 11:22 pm
I’ve found that I can control the order by editing the events_category_rel values in phpMyAdmin. I have over 250 rows and would rather not edit them all every time I load an event. Is there some kind of code that will keep this table sorted properly going forward?
Is there any kind of sql query I can run on the events already loaded to fix this?
I’m really stuck here and need to get this fixed.
Thanks!
|
|
Dean
|
January 7, 2013 at 6:28 am
Hi,
You could try the PHP function sort
This is an example from the link above. Basically you run the array through the sort function. You might not even need the foreach
<?php
$fruits = array("lemon", "orange", "banana", "apple");
sort($fruits);
foreach ($fruits as $key => $val) {
echo "fruits[" . $key . "] = " . $val . "\n";
}
?>
|
|
nickelmedia
|
January 7, 2013 at 9:34 pm
This option shows a defined array. Mine is not defined as it’s determined by which categories are clicked on the event?
I don’t understand why this is happening if the IDs of all of the categories are in order in the MySQL database?
There must be some code in EE somewhere along the way that can tell the database to spit out the category results in ASC order. I don’t care if I have to modify core files. This is a necessity.
Here is my code if it helps:
start_date, $format = 'm/d/y') ?>
id.'" show_address="false" show_description="false" show_map_image="false" title_wrapper="p" show_additional_details="false"]'); ?>
id.']') ?>
Ideally, I’d love to modify Category_Name as a custom shortcode and add the code here. Possible?
|
|
nickelmedia
|
January 7, 2013 at 9:37 pm
ummm… that’s not what I pasted as my code.
start_date, $format = 'm/d/y') ?>
id.'" show_address="false" show_description="false" show_map_image="false" title_wrapper="p" show_additional_details="false"]'); ?>
id.']') ?>
|
|
nickelmedia
|
January 7, 2013 at 9:39 pm
 Well, I guess code pasting doesn’t work.
|
|
Dean
|
January 8, 2013 at 12:18 am
Hi Jeff,
This will do what you want, but with one criteria – single digit numbers require a zero in front – eg 8U becomes 08U, otherwise in order, 10U comes before 8U (1 before 8).
<?php
$my_cats = do_shortcode('[CATEGORY_NAME event_id="' . $event->id . '"]');
$my_cats = explode(" ", $my_cats); //turns the string into an array
sort($my_cats);
foreach ($my_cats as $key => $val) {
echo $val . " ";
}
?>
|
|
nickelmedia
|
January 15, 2013 at 5:20 pm
Found out that PHP has built in Natural Support which solved the 0 in front issue.
Changed your code from sort($my_cats); to natsort($my_cats);
Problem solved! No need for 0’s and it’s all ordered correctly. Thank you so much! This has eluded me for weeks now!
|
|
Dean
|
January 15, 2013 at 11:24 pm
Hi Jeff,
No problem, and thanks for posting the natsort answer, very useful to know!
|
