i used the following query to fetch the tittle,data,tagss content,slug,parent id . this work fine […]
Tag: mysql
Can’t get variables to work in WPDB UPDATE query
I’ve tried all I can but this query will not work. I’ve tried prepare, adding […]
WordPress Query get posts based on custom table
I have some regular WordPress posts that I need to get from the database by […]
1 wordpress and 1 regular php website in one databse
I have a godaddy starter hosing plan which offers only one mysql database. I already […]
Woocommerce – Copy New Order Details to New Table
I found the below script somewhere on here before and having trouble getting it to […]
WordPress usermeta not being created
I have an unusual problem. When I create a new user in the WordPress back-end, […]
SQL Query for multiple values and multiple keys in the same table
Every post has two post meta: year and month (custom) I need SQL query to […]
wp_admin edit.php slow with lots of queries
I have about 4,000 posts. Currently when I click on All Posts (edit.php) it’s taking […]
num_rows always returns 1
global $wpdb; $wpdb->get_results(“SELECT * FROM wp_ap_promo WHERE wp_ap_promo.promocode = ‘”.$promocode.”‘ AND wp_ap_promo.business_id = ” . […]
Using PHP to select from an SQL table and removing a specific prefix from the results
I’ve got a wordpress installation where the post slugs are ‘r1’, ‘r2’, ‘r3’, ‘bah1’, ‘bah2’, […]
No More Posts Available.
No more pages to load.