I think if you add a couple of periods before and after the php variable in your query, remove the use of mysql_fetch_array, and use get_row(), it should work better. Here’s how I would get a park from your custom table: <?php $page_title = wp_title(”); $park = $wpdb->get_row(“SELECT * FROM $wpdb->park_data WHERE park_name=””.$page_title.”””); if($park) { … Read more
Gladly there’s a function that will output exactly that query string for you (still laughing about it 🙂 ). Here it is: get_posts_by_author_sql @queryposts.com, which looks in the core source like this. In detail it builds the WHERE part for you, that you can drop into your query. So just throw the user ID in … Read more
There is nothing wrong with your query, this is normal for WordPress. What is typically more important is the “total query time”. A well written theme with over 100 queries will often ring in under 20 milliseconds, that is 4-20 times faster than the blink of an eye. With a caching plugin you can can … Read more
First of all dont use Exec-PHP plugin, instead of it write your own. Second use $wpdb object (instance of WPDB class) to make all calls to database. http://codex.wordpress.org/Writing_a_Plugin http://codex.wordpress.org/Class_Reference/wpdb
Custom table(s). WordPress posts are not structurally a fit for what you are doing. Trying to use them for this will result in a lot of unnecessary data processing and storage. But you need to think through your own database design and you need to be good with SQL or you will end up inefficient … Read more
DISCLAIMER : Not a WordPress Developer, Just a MySQL DBA If you have privileges to login to MySQL and query data you could collect all the comment_ID values that have one word. SELECT comment_ID FROM wp_comments WHERE REPLACE(TRIM(comment_content),’ ‘,”)=TRIM(comment_content); You can test this by also seeing the comment_content SELECT comment_ID,comment_content FROM wp_comments WHERE REPLACE(TRIM(comment_content),’ ‘,”)=TRIM(comment_content); … Read more
Thank’s everyone for your attention. If anybody will need to query database with two postmeta, here is the code SELECT p.* , CASE WHEN m1.meta_value=0 OR m1.meta_value IS NULL THEN m2.meta_value ELSE m1.meta_value END meta_value FROM aka_v_posts p LEFT JOIN aka_v_postmeta m1 ON p.id=m1.post_id AND m1.meta_key=’_wpsc_special_price’ LEFT JOIN aka_v_postmeta m2 ON p.id=m2.post_id AND m2.meta_key=’_wpsc_price’ WHERE … Read more
Here are the Steps: STEP 01 : Put code in a Text File Open up a text editor (vi, nano, emacs) and place your code in it. Save it as /tmp/mynewcode.sql STEP 02 : Collect All Databases Names MYSQLCONN=`-uroot -ppassword` SQLSTMT=”SELECT schema_name FROM information_schema.schemata” SQLSTMT=”${SQLSTMT} WHERE schema_name NOT IN” SQLSTMT=”${SQLSTMT} (‘information_schema’,’performance_schema’,’mysql’)” mysql ${MYSQLCONN} -ANe”${SQLSTMT}” > … Read more
I have encountered the same kind of issue before, as you have already noted down the problem boiled down to mysql not accepting too many connections, The solution we implemented was to apply proper caching (check how often the cache is invalidated and other caching settings) and upgrade the mysql server. As a quick fix, … Read more
While the WPDB class, or its global $wpdb instance are your friend when it comes to querying custom tables or WP core data that does not have a higher-level API, it is overkill to use it to query posts. Instead, read up on WP_Query. In your case, you’d use it like so: $args = array( … Read more