Hi @George: Depending on how many musicians you expect to have in your database you could either go the full API route (which is generally preferred, whenever it is vialable) if you are going to have a large number of them (thousands?) you could go with some custom SQL to pull exactly the records you … Read more
That’s certainly something you must solve on the server side, only omitting the arguments in URL would cause errors when accessing the non-existent keys in the $_GET array. You should build your arguments array dynamically based on whether the values are set ot not. Example: $args = array(); foreach(array(‘s’, ‘country’, ‘year’) as $key) { // … Read more
But am looking for a plugin or a code which can help me with adding this note every time I write a post. A shortcode to add that “note” is trivial. function note_sc_wpse_107275($atts,$content) { return ‘<p class=”note”><strong>’.$content.'</strong></p>’; } add_shortcode(‘note’,’note_sc_wpse_107275′); Then just add [note]Note content[/note] to your post body. That will give you exactly what you … Read more
This is just a concept which you can try. By default, you cannot sort within the loop. You have, according to my knowledge, have two choices Create two loops and merging them. This, however, I would not recommend. Pagination and offsets are a nightmare if you are not completely comfortable with it Run your loop … Read more
You have a structural problem with your data. Serialized data in the database is terrible if you need to search over pieces of that serialized data. There is no reliable, efficient, and certainly no easy, SQL query to search over serialized data. “serialization” is a PHP mechanism. It isn’t SQL. To the database that is … Read more
Rather than attempt to fix your query, I recommend you sidestep it entirely by using custom post type archives! With permalinks on, you should be able to view a list of all your movies posts by going to: example.com/movies Then, in your theme, create archive-movies.php, and it will be used instead of the archive.php/index.php for … Read more
When you store an array as meta_value you are storing a string with serialized data that represents the original array. This format is appropriated for data that are only intended to display. Data that you plan to use for ordering or searching by or in any other way that is not just display the information … Read more
I think most pagination issues stem from a misunderstanding of the query and template loading process that happens before you are executing code within a template file. When someone requests a page: WordPress parses the request and decides what it’s for based on the incoming URL. For example, is it the main root page, does … Read more
Here are two ideas for your date_query part: 1) After 2 days ago: If you need posts published after current time, 2 days ago: ‘date_query’ => array( array( ‘after’ => ‘2 days ago’, // or ‘-2 days’ ‘inclusive’ => true, ), ), then the corresponding SQL part is: post_date >= ‘2014-09-09 17:57:15’ if the current … Read more
This isn’t complete copy/paste code, but hopefully it’s understandable enough to get you started. First step is to register your post type and add a rewrite rule to handle years/months. This will give you single events at event/post-name/, your post type archive at calendar, and handle incoming requests for calendar/yyyy/mm/. Make sure to visit your … Read more