jeribrooke

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?

Thanks so much, the plugin is excellent and I am happy it is active again.

I hope this plugin will be coming back soon – can you give any update?

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

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

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: https://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.

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 =

I forgot to mention I have tried both single and double quotes around the YES

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

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