Like those above, I’m trying to order by a numerical value (a price). I followed Roger’s advice and used ORDER BY ABS(0 + $wpdb->postmeta.meta_key) ASC
It seemed to work great, but every now and then a single entry will get ordered out of place. I can’t seem to figure out why, but with each of my lists, a single entry doesn’t seem to want to be placed in order.
Not sure what to do about it…
Thanks!