Warning: Please do not give out any FTP or ssh credentials to anyone, unless you trust them completely. Giving out login details is dangerous.

If the asker does not get an answer then they have 10 days to request a refund.

	



<?php 

	global $wp_query;

	$args = array_merge( $wp_query->query, array( 

					'post_type' => 'sporet_event',

					'meta_key' => 'start_date',

					'orderby' => 'meta_value_num',

					'order' => 'desc'

					) 

				);

	query_posts( $args );

	 if (have_posts()) : while (have_posts()) : the_post(); ?>

	



	<li><?php echo get_post_meta($post->ID, 'start_date', true); ?></li>



        <li><?php the_title(); ?></li>



	<li><?php echo get_post_meta($post->ID, 'sport_type', true); ?></li>



	<?php endwhile; ?>

<form name="myform" action="localhost/wordpress/events" method="GET">

    <select name="rating-search" id="rating-search" OnChange="document.myform.submit()">

        <option value="at_event_null">select</option>

        <option value="at_event_type---asc">type asc</option>

        <option value="at_event_type---desc">type desc</option>

        <option value="at_event_start_date---desc">start desc</option>

        <option value="at_event_start_date---asc">start asc</option>

        <option value="place">place</option>



    </select>

 </form>

	<?php 

	

	// Example 1

$select  = $_GET['rating-search'];

$value = explode("---", $select);

$value[0]; // meta key

$value[1]; // asc or desc

	

	global $wp_query;

	global $wp_query;

	$args = array_merge( $wp_query->query, array( 

					'post_type' => 'events',

					'meta_key' => $value[0],

					'orderby' => 'meta_value_num',

					'order' => $value[1]

					) 

				);

	query_posts( $args );

	 if (have_posts()) : while (have_posts()) : the_post(); ?>

Wordpressing | 12/22/11 at 5:04am Edit

Previous versions of this question: 12/22/11 at 5:06am | 12/22/11 at 10:55am

(6) Possible Answers Submitted...

See a chronological view of answers?

Warning: Please do not give out any FTP or ssh credentials to anyone, unless you trust them completely. Giving out login details is dangerous.

• 
  Last edited:
  12/22/11
  5:18am
  Gabriel Reguly says:

  Hi WordPressing,
  
  In which format are you storing your dates? start_date is Y-m-d or d/m/Y?
  
  This most likely is your first issue.
  
  Regards,
  Gabriel
  
  

  • 12/22/11 5:20am
    
    Wordpressing says:

    Hi Gabriel,
    
    d/m/Y

  • 12/22/11 5:22am
    
    Gabriel Reguly says:

    Hi Wordpressing,
    
    For your second issue, please try this code:
    
    

    
    
    $select  = $_GET['rating-search'];
    
    if ( ! empty( $select ) ) { 
    
      $value = explode("---", $select);
    
    } else {
    
      $value[0] = 'start_date';
    
      $value[1] = 'desc';
    
    }
    
    

    
    
    Regards,
    Gabriel

  • 12/22/11 5:27am
    
    Gabriel Reguly says:

    Hi Wordpressing,
    
    As John already explained,you will need to change the storing format of your dates.
    
    Is post type events coming from a plugin or is that custom code?
    
    Be warned that you will need to amend code for any instance where you display your events dates, but that is the correct way to deal with this issue.
    
    Regards,
    Gabriel

  • 12/22/11 5:49am
    
    Wordpressing says:

    I am using a plugin Advanced Custom Fields so I don't think I can change the storing format of the date field unless I forgo the ability to use the datepicker.,

  • 12/22/11 5:58am
    
    Gabriel Reguly says:

    Hi Wordpressing,
    
    The datepicker ( from jQuery ) can output any date format, it shall be no issue.
    
    Follows code from my jquery.ui.datepicker-pt-BR.js, I use it in a theme custom made for a client.
    
    

    
    
    jQuery(function($){
    
    	$.datepicker.regional['pt-BR'] = {
    
    		closeText: 'Fechar',
    
    		prevText: '<Anterior',
    
    		nextText: 'Próximo>',
    
    		currentText: 'Hoje',
    
    		monthNames: ['Janeiro','Fevereiro','Março','Abril','Maio','Junho',
    
    		'Julho','Agosto','Setembro','Outubro','Novembro','Dezembro'],
    
    		monthNamesShort: ['Jan','Fev','Mar','Abr','Mai','Jun',
    
    		'Jul','Ago','Set','Out','Nov','Dez'],
    
    		dayNames: ['Domingo','Segunda-feira','Terça-feira','Quarta-feira','Quinta-feira','Sexta-feira','Sábado'],
    
    		dayNamesShort: ['Dom','Seg','Ter','Qua','Qui','Sex','Sáb'],
    
    		dayNamesMin: ['Dom','Seg','Ter','Qua','Qui','Sex','Sáb'],
    
    		weekHeader: 'Sm',
    
    		dateFormat: 'dd/mm/yy',
    
    		firstDay: 0,
    
    		isRTL: false,
    
    		showMonthAfterYear: false,
    
    		yearSuffix: ''};
    
    	$.datepicker.setDefaults($.datepicker.regional['pt-BR']);
    
    });
    
    

    
    
    Sorry, but I need to go offline.
    
    Other experts shall be able to help you.
    
    Good luck,
    Gabriel

• 
  Last edited:
  12/22/11
  5:21am
  Arnav Joy says:

  have you trie orderby='meta_value' in $args array
• 
  Last edited:
  12/22/11
  5:21am
  John Cotton says:

  hen a user decides to filter results, I need the same query to be modified with the select values all the while still staying on the same page

  
  
  Then you should change your form code to this:
  

  
  
  <form name="myform" action="" method="POST">

  
  
  That way, the page stays the same and you just need to pick up the $_POST values to adjust your output.
  
  On the meta value, you're in difficulties trying to sort a date string as a number!
  
  I think you've got two options:
  
  1/ Store the dates as time values (which is a number), then the number sort would work
  2/ Store the dates as date string (ie as you are now) remove the sorting from the query posts and do a uasort on $wp_query->posts with a custom function that does a proper date sort.
  
  Personally, I would go for the first as it's more reliable in the long term and not very difficult to change your current code. You'd just need to format the time ( date('d/m/Y', $meta) ) before output.
  

  • 12/22/11 10:57am
    
    Wordpressing says:

    Thanks John!

• 
  Last edited:
  12/22/11
  5:22am
  Francisco Javier Carazo Gil says:

  Hi Wordpressing,
  
  Dates are in Spanish format and you cannot order directly. You have some posibilities.
  
  I recommend you to create a new meta value with date in this format: YYYY-MM-DD so the orderby works well.
  
  Other posibility is SELECT all rows, saved them in an array and order it. You will have to split this string.
  

  
  
  list($day, $month, $year) = split('/', $date);
  
  

  • 12/22/11 5:23am
    
    Francisco Javier Carazo Gil says:

    The second problem can be solved by John Solution.

• 
  Last edited:
  12/22/11
  5:24am
  Julio Potier says:

  Hello
  
  Sory but WP Queries can not sort a meta field by date, 2 possibilities are "string" or "number"
  Now i have to tell you that when you save a date, you have to do this :
  YYYY-MM-DD (or / or whatever for separator)
  or the time() !
  Can you go back in time and change this ?
  You'll save time and headache ^^

  • 12/22/11 5:25am
    
    Julio Potier says:

    Or you can create you own query and cast the meta_field in date;
    Kind of "...ORDER BY CAST(meta_value as DATE)"

• 
  Last edited:
  12/22/11
  5:26am
  Hai Bui says:

  Hi,
  
  For problem #1: You should use this format for the date: yyyy/mm/dd and use

  'orderby' => 'meta_value'

  instead of

  'orderby' => 'meta_value_num' 

  
  I think this is the only way you can sort the results by date in custom field. If you need to display the date in a different format, you can use extra function to convert the date to the format you wanted.
  
  For problem #2:
  
  

  <?php 
  
  
  
  	// Example 1
  
  
  
  // if there is a rating-search value in url, then use it to sort, otherwise use 'start_date'
  
  $select  = $_GET['rating-search']?$_GET['rating-search']:'start_date---desc';
  
  
  
  $value = explode("---", $select);
  
  
  
  $value[0]; // meta key
  
  
  
  $value[1]; // asc or desc
  
  
  
  	
  
  	global $wp_query;
  
  
  
  	global $wp_query;
  
  
  
  	$args = array_merge( $wp_query->query, array( 
  
  
  
  					'post_type' => 'events',
  
  
  
  					'meta_key' => $value[0],
  
  
  
  					'orderby' => 'meta_value_num',
  
  
  
  					'order' => $value[1]
  
  
  
  					) 
  
  
  
  				);
  
  
  
  	query_posts( $args );
  
  
  
  	 if (have_posts()) : while (have_posts()) : the_post(); ?>

  
  
  

  • 12/22/11 5:56am
    
    Wordpressing says:

    Hi Hai,
    
    I'm trying to implement the code for problem #2 but when I navigate to
    
    localhost/wordpress/events
    
    I receive a 404 Not Found
    
    I am still able to use the select menu but I can't load the default page with it's default start_date query.
    
    Also if I store the date in yyyy/mm/dd what is one such way that I can manipulate it's display in the browser back to dd/mm/yyyy?
    
    Thank you,
    WP

  • 12/22/11 6:09am
    
    Hai Bui says:

    Should the field be 'at_event_start_date' instead of just 'start_date'? You use 'start_date' in the first example and 'at_event_start_date' in the form field values, I'm not sure which one is correct. If 'at_event_start_date' is the correct custom field, please change:
    
    

    $select  = $_GET['rating-search']?$_GET['rating-search']:'at_event_start_date---desc';

    
    
    About converting the date format to 'dd-mm-yyyy', you can use this code:
    <?php
    $time = strtotime($date); // with $date is the date in yyyy/mm/dd
    echo date( 'd-m-Y', $time ); // print date in dd/mm/yyyy format
    ?>

This question has expired.

Wordpressing, Julio Potier voted on this question.

Current status of this question: Completed

Warning: Please do not give out any FTP or ssh credentials to anyone, unless you trust them completely. Giving out login details is dangerous.

If the asker does not get an answer then they have 10 days to request a refund.