Tagged Questions
0
votes
2answers
239 views
Up/Down voting system for Wordpress
Looking in all posts with keywords "voting system, upvote, downvote", I can't find a satisfying solution for this issue, except accepting one of the available plugins, spend a lot of time undersanding ...
0
votes
0answers
58 views
Convert date format in meta
I have been storing date format in meta key/value. I have been storing in this format (mm/dd/YYYY) now I need to convert that into (YYYYMMDD) SO I can run a date match in query.
Please advice how can ...
1
vote
0answers
30 views
Meta Query And/Or
My question is very similar to Meta Query with AND & OR? . This question was answered in 2011 by @Otto.
With the exception that my logic is different.
I want to query, for example, posts with ...
0
votes
0answers
58 views
Custom Wordpress Meta Query
I have a post type (course) that has some meta data associated with it, namely the following two:
City and State
The two pieces of data above are stored in the postmeta table, with meta_keys ...
0
votes
1answer
84 views
Bulk move (or copy) from a custom field to the post content?
I need to move (or copy) the contents of a custom field into the main post body, replacing any existing content.
I need to do this for a few hundred posts...Is there a quick way of doing this?
I can ...
0
votes
1answer
190 views
Show array of meta_value in Edit Post Coloum
what I'm trying to do is add a new coloumn to Edit post page (done) and in that coloumn show data taken from a set of custom fields (partially done).
This is my code (I use it as a plugin so it ...
3
votes
2answers
648 views
SELECT max(meta_value) FROM wp_postmeta WHERE meta_key='price'… stops working when value is over 999
Overview: I am not trying to return a post. I simply want the single highest value for a particular meta_value across all posts... just the value itself.
Details: I have added a custom meta_key ...
0
votes
1answer
197 views
Alter SQL query to return posts with unique custom field value, no duplicate values
I currently have a list of posts with the custom field "Name," with several posts having the same value for "Name."
I would like to retrieve a list of posts that all have unique values for "Name." ...
0
votes
1answer
2k views
Retrieving custom fields with $wpdb->get_results
I'm trying to use $wpdb->get_results to retrieve an array of all posts including custom fields. I can retrieve the meta_key and meta_value columns like this:
[meta_key] => state [meta_value] ...
0
votes
2answers
404 views
How to rename a custom field?
I have 3000 posts with that custom field name 'refer' and i need to change it to 'ref' for theme needs, instead of doing it manually i need a query or technique to change them all.
Question 1
I am ...
1
vote
1answer
967 views
Order query by meta_value with multiple custom fields
I would like to get ordered all my posts with multiple cutom fields (WordPress 3).
Exemple, I've 2 custom couple meta_key/meta_value :
" order_submenuexpositions / numeric "
" ...
4
votes
2answers
2k views
How to correctly call custom field dates into a posts_where filter using SQL statements
Currently I have the loop listing posts between two dates using the posts_where filter:
function filter_where( $where = '' ) {
$where .= " AND post_date >= '2000-01-01' AND post_date <= ...
