Forum Replies Created
-
Posts
-
I don’t know if I explained very well; I’d like to order the search results based on startdate of memberships, so, for expample if an user has a membership startdate on 1th january 2019, and changes today it’s membership to other membership, his new membership startdate would be Today (5th may 2019).
Thank you,
Hello Ernest, I can’t make it work; I’ve got this code under the last one; would you mind taking a look, please?
$theusers = $wpdb->get_results($sqlQuery);
$totalrows = $wpdb->get_var(“SELECT FOUND_ROWS() as found_rows”);//update end to match totalrows if total rows is small
if($totalrows < $end)
$end = $totalrows;$layout_cols = preg_replace(‘/[^0-9]/’, ”, $layout);
if(!empty($layout_cols))
$theusers_chunks = array_chunk($theusers, $layout_cols);
else
$theusers_chunks = array_chunk($theusers, 1);ob_start();
Thank you,
Ops! sorry, I checked it wrong:
If I remove DESC I get the results order by ASC, but not for membership startdate.
No, it doesn’t work,
‘orderby’ => ‘ mu.startdate DESC, ‘,
or
‘orderby’ => ‘ startdate DESC, ‘,It doesn’t do nothing. Only if I remove DESC the results order is ASC
Hello Ernsert, thank you, it’s almost done:
‘orderby’ => ‘ startdate DESC, ‘, doesn’t do nothing.
If I remove DESC:
‘orderby’ => ‘ startdate, ‘, I get the results ordered in ASC
I tried adding:
‘order’ => ‘DESC’, but doesn’t work
Thank you,
Hi Ernest, would it be possible to display de images using the advanced title field {foto} in some way ? {foto} just displays the image ID
Thank you,
