0

I'm using WordPress and custom_post_type. I have an array (php) and I would like to sort this one by date but by default sort by post_id :

First, I have a SQL query to load my posts from custom_post_type. For each post, if start date > current date :

global $wp_query;
$args = array(
    'posts_per_page' => '9999999',
    'orderby' => 'event_start_date',
    'post_type'=> 'ai1ec_event',
    'events_categories' => 'events',
    'order' => 'DESC',
    'post_status' => 'publish'
);
$the_query = new WP_Query( $args );
$tabId = array();

if ( $the_query->have_posts() ) {
    while( $the_query->have_posts() ) {
        $the_query->the_post();
        global $post;
        $idEvent = $post->ID;

$sql = "SELECT * FROM og2rm_ai1ec_events WHERE post_id = ".$idEvent.";";
$results = $wpdb->get_results($sql);

foreach($results as $event)
{
    $start_date = $event->start;
    $end_date = $event->end;
    $heure = date("Y-m-d", $event->start);
    $currentDate = date("Y-m-d");
    $todayStr = strtotime ($currentDate);
    $lieu = $event->address;
    $rue = $event->venue;

    if($start_date > $todayStr){
        $a++;
        $tabId[$idEvent] = array('debut'=>$start_date,"lieu"=>$lieu,"rue"=>$rue,"fin"=>$end_date);
        }
    }

$tabId[$idEvent] = array('debut'=>$start_date,"lieu"=>$lieu,"rue"=>$rue,"fin"=>$end_date);

/******* echo <pre> $tabId : *******/

[21379] => Array
    (
        [debut] => 1510336800
        [lieu] => Example
        [rue] => Example
        [fin] => 1510340400
    )

[21376] => Array
    (
        [debut] => 1510268400
        [lieu] => Example
        [rue] => Example
        [fin] => 1512255600
    )

[21375] => Array
    (
        [debut] => 1511616600
        [lieu] => Example
        [rue] => Example
        [fin] => 1511620200
    )

[21372] => Array
    (
        [debut] => 1511530200
        [lieu] => Example
        [rue] => Example
        [fin] => 1511533800
    )

And now, I did another foreach to display my posts but display by ID not by date.

I tried array_multisort or ksort / sort byt doesn't work.

Any idea ?

Thanks/

Reitrac
  • 93
  • 9

0 Answers0