Ordering WP Posts by Custom Meta Key

wordpress unix-timestamp getdate
cqde picture cqde · May 27, 2011 · Viewed 30.5k times · Source

I created a WordPress custom post type to be able to create events, select the event's date, and display the date on the frontend.

I added a new meta_key in the postmeta of WP's database to store the event's date in a UNIX timestamp.

I've had no trouble creating a new WP query to output my events on my site but I am trying to figure out how to organize the events by their UNIX timestamp in the database, not by the date that WordPress created the events.

I can't seem to wrap my head around the thing.. any advice?

Answer

yitwail picture yitwail · May 27, 2011

I believe your query can have 

'orderby' => 'meta_value_num',
'meta_key' => 'event_timestamp' //or whatever your meta_key is

you can read about it here: http://codex.wordpress.org/Class_Reference/WP_Query#Order_.26_Orderby_Parameters

Related questions

Access denied for user 'root@localhost' (using password:NO)

I'm new to MySQL, I'm trying to run WordPress in my Windows desktop and it needs MySQL. I install everything with Web Platform Installer which is provided by Microsoft. I never set a root password for MySQL and in the …

Read More
Create a folder if it doesn't already exist

I've run into a few cases with WordPress installs with Bluehost where I've encountered errors with my WordPress theme because the uploads folder wp-content/uploads was not present. Apparently the Bluehost cPanel WordPress installer does not create this folder, though …

Read More
Correct file permissions for WordPress

I've had a look over here but didn't find any details on the best file permissions. I also took a look at some of WordPress's form's questions over here too but anybody that suggests 777 obviously needs a little lesson in …

Read More