Title: jeribrooke's Replies | WordPress.org --- # jeribrooke [ ](https://wordpress.org/support/users/jeribrooke/) * [Profile](https://wordpress.org/support/users/jeribrooke/) * [Topics Started](https://wordpress.org/support/users/jeribrooke/topics/) * [Replies Created](https://wordpress.org/support/users/jeribrooke/replies/) * [Reviews Written](https://wordpress.org/support/users/jeribrooke/reviews/) * [Topics Replied To](https://wordpress.org/support/users/jeribrooke/replied-to/) * [Engagements](https://wordpress.org/support/users/jeribrooke/engagements/) * [Favorites](https://wordpress.org/support/users/jeribrooke/favorites/) Search replies: ## Forum Replies Created Viewing 10 replies - 1 through 10 (of 10 total) * Forum: [Reviews](https://wordpress.org/support/forum/reviews/) In reply to: [[Appointment Hour Booking - Booking Calendar] Perfect Solutions for my Problem](https://wordpress.org/support/topic/perfect-solutions-for-my-problem/) * [jeribrooke](https://wordpress.org/support/users/jeribrooke/) * (@jeribrooke) * [4 years ago](https://wordpress.org/support/topic/perfect-solutions-for-my-problem/#post-15637392) * I just installed this plugin, can you tell me how you configured it to have the option for 2 courts if pickleball and 1 for tennis? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Advanced File Manager – Ultimate File Manager for WordPress And Document Library Solution] Plugin closed?!?](https://wordpress.org/support/topic/plugin-closed-25/) * [jeribrooke](https://wordpress.org/support/users/jeribrooke/) * (@jeribrooke) * [4 years, 7 months ago](https://wordpress.org/support/topic/plugin-closed-25/#post-14949615) * Thanks so much, the plugin is excellent and I am happy it is active again. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Advanced File Manager – Ultimate File Manager for WordPress And Document Library Solution] Plugin closed?!?](https://wordpress.org/support/topic/plugin-closed-25/) * [jeribrooke](https://wordpress.org/support/users/jeribrooke/) * (@jeribrooke) * [4 years, 7 months ago](https://wordpress.org/support/topic/plugin-closed-25/#post-14948696) * I hope this plugin will be coming back soon – can you give any update? * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Events Manager - Calendar, Bookings, Tickets, and more!] Google map api error on mobile device after upgrade](https://wordpress.org/support/topic/google-map-api-error-on-mobile-device-after-upgrade/) * Thread Starter [jeribrooke](https://wordpress.org/support/users/jeribrooke/) * (@jeribrooke) * [7 years ago](https://wordpress.org/support/topic/google-map-api-error-on-mobile-device-after-upgrade/#post-11531693) * Yes, I have the api’s enabled. After receiving your recommendation, I cleared all website history and data on my cell phone and the maps worked again. Thanks * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[EZ SQL Reports Shortcode Widget and DB Backup] sqlgetvar does not return result](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result/) * Thread Starter [jeribrooke](https://wordpress.org/support/users/jeribrooke/) * (@jeribrooke) * [10 years, 2 months ago](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result/#post-7130536) * Aloha, Thank you so much for your response. I added your code above into elisqlreports/ trunk/index.php and it worked! What a great plugin and support, I will try to get some funds to donate to your efforts. (By the way is there a way to export a csv from your reports?) Thanks again for everything. Jeri * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[EZ SQL Reports Shortcode Widget and DB Backup] sqlgetvar does not return result](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result/) * Thread Starter [jeribrooke](https://wordpress.org/support/users/jeribrooke/) * (@jeribrooke) * [10 years, 2 months ago](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result/#post-7130493) * I changed them to UCASE and still no result for the queries. * I had found on the internet references to UPPER and LOWER for mySQL: FROM: [http://www.sqlinfo.net/mysql/mysql_function_upper_lower.php](http://www.sqlinfo.net/mysql/mysql_function_upper_lower.php) * You can use either the MySQL UPPER() or LOWER() functions to format columns in your SQL SELECT. An example they give on the page is: Return rows for a column case insensitive * It is common practice to make a column case insensitive to ensure that you return all of the desired rows. * SELECT * FROM Courses WHERE LOWER(education_delivery_method) = ‘classroom’ * I guess I have a lot to learn about mySql. Thanks for all your ideas. * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[EZ SQL Reports Shortcode Widget and DB Backup] sqlgetvar does not return result](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result/) * Thread Starter [jeribrooke](https://wordpress.org/support/users/jeribrooke/) * (@jeribrooke) * [10 years, 2 months ago](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result/#post-7130479) * I tested using a different field just to make sure active was not the issue. The count should be 1 and is 1 in the phpadmin sql screen for all the selects with first_name_2. * members = [sqlgetvar]SELECT count(*) FROM wp_participants_database [/sqlgetvar] members1 = [sqlgetvar]SELECT count(*) FROM wp_participants_database WHERE account_number = 1877 [/sqlgetvar] members2 = [sqlgetvar]SELECT count(*) FROM wp_participants_database WHERE UPPER(first_name_2) = ‘JERI'[/sqlgetvar] members3 = [sqlgetvar]SELECT count(*) FROM wp_participants_database WHERE UPPER(first_name_2) LIKE ‘JERI%'[/sqlgetvar] members4 = [sqlgetvar]SELECT count(*) FROM wp_participants_database WHERE UPPER( first_name_2) LIKE “JERI%”[/sqlgetvar] members5 = [sqlgetvar]SELECT count(*) FROM wp_participants_database WHERE UPPER(`first_name_2`) LIKE ‘JERI%'[/sqlgetvar] members6 = [sqlgetvar]SELECT count(*) FROM wp_participants_database WHERE UPPER(` first_name_2`) LIKE “JERI%”[/sqlgetvar] * RESULTS: members = 449 members1 = 1 members2 = members3 = members4 = members5 = members6 = * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[EZ SQL Reports Shortcode Widget and DB Backup] sqlgetvar does not return result](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result/) * Thread Starter [jeribrooke](https://wordpress.org/support/users/jeribrooke/) * (@jeribrooke) * [10 years, 2 months ago](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result/#post-7130454) * I forgot to mention I have tried both single and double quotes around the YES * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[EZ SQL Reports Shortcode Widget and DB Backup] sqlgetvar does not return result](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result/) * Thread Starter [jeribrooke](https://wordpress.org/support/users/jeribrooke/) * (@jeribrooke) * [10 years, 2 months ago](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result/#post-7130453) * Sorry I am new to mysql, but believe the issue is in the where clause, not quite sure I understand why but here is what I have found: members = [sqlgetvar]SELECT count(*) FROM wp_participants_database [/sqlgetvar] members1 = [sqlgetvar]SELECT count(*) FROM wp_participants_database WHERE UPPER(active)=’YES’ [/sqlgetvar] * The page displays the following: members = 449 members1 = * in the phpadmin mysql I get the following: * SQL query SQL query: SELECT count( * ) FROM wp_participants_database WHERE UPPER( active ) = ‘YES’ Profiling [ Edit ] [ Explain SQL ] [ Create PHP Code ] [ Refresh] * count(*) 398 * Thanks for everything Jeri * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[EZ SQL Reports Shortcode Widget and DB Backup] sqlgetvar does not return result](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result/) * Thread Starter [jeribrooke](https://wordpress.org/support/users/jeribrooke/) * (@jeribrooke) * [10 years, 2 months ago](https://wordpress.org/support/topic/sqlgetvar-does-not-return-result/#post-7130449) * Aloha, Thank you so much for your quick response. I removed the line break in the simple sql and it worked. * I tested with a more complex sql that does not have any line breaks and it does not work in the [sqlgetvar] but does work in the phpMyAdmin sql. I wonder if you have any can see any issues with this sql: * SELECT sum(members) members FROM (SELECT count( last_name_1 ) members FROM wp_participants_database WHERE UPPER(active)=’YES’ UNION SELECT count( last_name_2 ) members FROM wp_participants_database WHERE last_name_2 != “” AND last_name_2 IS NOT NULL AND upper(active) = ‘YES’) m * Mahalo, Jeri Viewing 10 replies - 1 through 10 (of 10 total)