I found the errors thanks to the help from @Milo @Milo’s query on catno pointed me to my error with my first query involving catno, and I also noticed a double equals in $catno == $row[0]; when it should be $catno = $row[0]; Final coding is function QueryStock($cat) { $query = “SELECT * FROM stock … Read more
Update all fields of table with ON DUPLICATE KEY UPDATE command
Ajax Form data is not posted back to the get_results()
Option 1 – Grab the post ID at the same time You can also select the post_id field when you running your query, allowing you to then get the post with a call to get_post($values->post_id); (if required). global $wpdb; $query = $wpdb->prepare(‘ SELECT p.post_id, p.meta_value FROM %1$s AS p WHERE p.meta_key = “post_views_count”‘, $wpdb->postmeta ); … Read more
Query postmeta values, and return multiple post_titles for common meta value
Ordering list of users by last name and then by first name
dbdelta demands that: You must put each field on its own line in your SQL statement. You must have two spaces between the words PRIMARY KEY and the definition of your primary key. You must use the key word KEY rather than its synonym INDEX and you must include at least one KEY. You must … Read more
I ended up figuring this out by realizing that I could build a list of coauthor id’s using the template tags that ship with the coauthors plugin. Next, I observed how WordPress core does joins to query by taxonomy, but var_dumping the posts_request on a term archive page. At that point, I just had to … Read more
Use a global. So, your plugin file would look like this: $myConn = new wpdb( ‘username’, ‘password’, ‘database’, ‘localhost’ ); function plugin_step_1( $arg1, $arg2 ) { global $myConn; //code to do stuff here } function plugin_step_2() { global $myConn; // more code here } function plugin_step_3( $arg1 ) { //I don’t need the wpdb object … Read more
Save customizer default values to DB on theme activation