CODEWITHSUNDEEP
mysqlwordpress
user2151960
user2151960

Reputation: 185

get_results $wpdb order by name asc

I am trying to sort data ordered alphabetically.

 $myrows = $wpdb->get_results($wpdb->prepare("SELECT name, term_id FROM wp_catidx WHERE alpha = %s", $pageletter));

I tried dozens of ways and i did not succeed, can someone help me? Thank you!

Upvotes: 0

Views: 2185

Answers (2)

AHSAN KHAN
AHSAN KHAN

Reputation: 436

you can sort data by adding "ORDER BY name ASC"

 $myrows = $wpdb->get_results($wpdb->prepare("SELECT name, term_id FROM wp_catidx WHERE alpha = %s ORDER BY name ASC", $pageletter));

Upvotes: 3

John Ellmore
John Ellmore

Reputation: 2229

This should work:

$myrows = $wpdb->get_results($wpdb->prepare(
    "SELECT name, term_id
    FROM wp_catidx
    WHERE alpha = %s
    ORDER BY name",
$pageletter));

Upvotes: 1

Related Questions