found the solution <3 Used WHERE ‘$startday’ BETWEEN dstart AND dend plus : OR dstart >= ‘$startday’ SELECT * FROM wp_posts, wp_mec_dates AS mecd, wp_icl_translations WHERE wp_posts.ID = mecd.post_id and post_status=”publish” AND wp_icl_translations.language_code=”$lang” AND (‘$startday’ BETWEEN dstart AND dend OR dstart >= ‘$startday’) AND wp_posts.ID = wp_icl_translations.element_id ORDER BY dstart LIMIT 0,6
The WordPress plugin repository has several “export to CSV” plugins available. For example this one looks interesting. Its also a good startpoint if you don’t want to use a plugin and code this on your own.
This a php syntax error, try: foreach($last_updated_comment as $key => $last_comment_date){ print_r( $last_comment_date ); echo “<br /><br />”; }
Let me try to summarize what you want and answer: I want on main page (index.php) retrieve page(News) url and title. So you have a “News” page that’s using a specific template called “News” and you want to grab that page’s ID, URL, and title to display on the front page, correct? Get a Page … Read more
If you have several posts with the same value, but you want only the most recent ones with any value, as long as values don’t get repeated, you’r best bet might be running two loops on the same query: /* Fetch all possible values – use this to order the results and define which get … Read more
You can also use the import/export tools available from wordpress itself. Maybe try a clean install and import your data from there. It will be a better and more clean migration. Your import/export Tools will be in Admin->Tools. If you are looking to import a MySQL database from a MySQL dump, (filename.sql), you can do … Read more
I think the problem is in your transient set_transient( “7677recent_$my_paged”, $my_query, 60 * 60 ); This is currently refreshing every 1 hour you could try changing it to 3 or 5 mins for testins
Thanks to some leads from the wp-hackers list on this very question and some googling around, here is the answer to my problem $sql = “SELECT count(*) as count,terms2.name as tag FROM wp_posts as p1 LEFT JOIN wp_term_relationships as r1 ON p1.ID = r1.object_ID LEFT JOIN wp_term_taxonomy as t1 ON r1.term_taxonomy_id = t1.term_taxonomy_id LEFT JOIN … Read more
Arbitrary SQL query can be run via wpdb by using get_results() method: $results = $wpdb->get_results( $query ); You can work through documentation for wpdb at Codex to gain basic understanding of how it works.
I can’t comment yet, so I’ll tell you here what you can change immediately: $countryinfo = $wpdb->get_row(“SELECT * FROM wp_num_countries WHERE countryID = “.$country_id); to $countryinfo = $wpdb->get_row($wpdb->prepare(“SELECT * FROM wp_num_countries WHERE countryID = %d”, $country_id)); because you directly use $_POST variable, so $wpdb->prepare will format and prepare your query string. But that code looks … Read more