In general I try to avoid custom SQL queries as much as i can and use the native WordPress functions but in some cases its much better/faster to use custom queries. if the case is just get a list of posts the you can use the WP_Query or get_posts which will work almost as fast … Read more
You can’t query the database for a value in the array. However you can grab the entire array and parse the array to get your value. Check out PHP ARRAY-VALUES. More than likely you’ll need to use a for each statement. Does the value your trying to get appear in the same spot in the … Read more
This a php syntax error, try: foreach($last_updated_comment as $key => $last_comment_date){ print_r( $last_comment_date ); echo “<br /><br />”; }
Modify your query and use the SQL alias as: $my_row = $wpdb_c->get_results(“SELECT Employee.Name as Employe_Name, Area.Name as Area_Name, Area.Region as Area_Region FROM Area INNER JOIN Employee ON Area.ID = Employee.Area_ID WHERE Employee.ID = ” . get_the_ID()); Then in your code use: $my_row[0]->Area_Name
You can do it easily. Your query should be: $querystr = “SELECT `term_id` AS `id`, `name` AS `value`, `slug`, `term_group` FROM {$wpdb->terms} WHERE lower($wpdb->terms.name) like ‘%$s%'”; See, here i’ve mentioned the name of the fields needed. For any other fields, you need to explicitly mention the field names.
Probably some code on your site caches the result of an expensive operation. When the page is cached by W3TC, if on the very same page generation, cache was being regenerated, you will see the actual queries that operation requires. After that, queries are like the usual page load ones. Don’t worry about it until … Read more
Technically, you should use WP’s built-in class WP_Query to pull the information and I am sure that will alone simplify your entire process.
I personally try to stay away from mysql queries when I can use WordPress functions to achieve the same thing. You could try using get_users, Is this what you are trying to achieve: <?php $blogusers = get_users(‘meta_value=Referral’); foreach ($blogusers as $user) { echo $user->user_email; } ?> Untested. But that should display every user with a … Read more
this: $temp_array = array(‘status’, ‘0’); should be $temp_array = array(‘status’ => ‘0’);
You can do that. There are filters available in WP_Query that enable you to modify the query just as you like. The filter posts_clauses filters all of the parts of the query together. There are also filters specific to the parts of the query too. The best way to know about them is, search posts_clauses … Read more