The problem is, there might be 1, 2, 3, 4 or N levels of depth in the subcategories. So, writing the query is possible, but inefficient because to be this flexible, left joins will be required which are not fast.
mysql_real_escape_string() vs. esc_sql() in WordPress
WordPress page and plugin list using sql query
After struggling with different functions , I figure out $wpdb->get_row() and $wpdb->get_var()The first one returns rows into an associative array or numerical array , depends on the second argument in $wpdb->get_row(‘query’,ARRAY_A or ARRAY_N or OBJEECT) and the second one that I used to solve my problem return only one variable from particular table.e.g, <?php $user_count … Read more
How to add a private user page populated from sql?
You’re right that the problem is a result of the explode on semi-colons. We can use the dbdelta_queries filter to fix it. In this solution we’re assuming that all queries start with CREATE, INSERT or UPDATE. If you have queries you’re running through dbDelta where this isn’t the case, the preg_match line will need adjusting … Read more
Regarding “Insert query error” in wordpress
Proper usage of $wpdb->update()?
inserting a post from an extern php file but post content doesn’t show on wp site
Well, the error message kinda explains itself. The plugin probably want to create some tables but your woedpress user, the one indicated in wp-config.php, do not have a table create permissions. You will have to go into your MySQL administration panels and give the user the create permission as well.