https://github.com/...8073ca89b0897f77a3ea

Apply Paul's solution because it is compatible with MySQL !!!!

The low-cost servers among them "pass" tasks and there is no way to know where your tables are or how they are managed, so it is best that the PHP code is very clear and explicit in SQL queries.

We must find that it is compatible with all managers at all costs. Especially if you do not have your own server managed by you.

You don't care about adding those quotes and trying again.

Keep us informed! 

I tried several times using the quote " character and the result was a white screen.  When I figured out that I had to use the back quote ` character the search function worked perfectly.  (see attached)

Thank you both for your help. It is very much appreciated! 

There are three types of quotes, I call them left, single and double.

If you "open" with one type you have to "close" with the other or secure blank screen.

And if within one type you open and close another there is a range of priorities, if you respect the order <double> <single> <left> " ' ` whatever ` ' " <left> <single> <double> you will not have problems but if you do not do so you will have unexpected results.

In this case, the truth is that the OxWall SQL expression is incorrect, but MySQL tries to "quote" what it does not understand before giving an error and MariaDB - which is more coarse - makes an error directly.

This I have found out experimentally ... when I studied computer a floppy disk of a few Kb measured what a pizza and we did not have so many letters.

"There are three types of quotes, I call them left, single and double."

Thanks for the information on the different type of quotes. This was the first time I've needed to use the left quotes. I have some training in computer programming but I'm not a programmer by profession. I am able to edit scrips that others have written.  I'm lost when it comes to databases. Without the help I received on this forum I would have never been able to figure out this problem. Thanks again.

"when I studied computer a floppy disk of a few Kb measured what a pizza and we did not have so many letters."

The first programming I did was in BASIC on a Commodore Vic-20 computer that had 5k of memory. It stored programs on a cassette tape. :)

Any help or hit will be appreciated. 

Just FYI the left quote Patricia is referring to is called a tilde (pronounced til-dee), its only really ever used IMO in sql commands for database transactions.  On common keyboards its located on the left side of the #1 key on the top of the keyboard. 

This is a tilde `  used almost exclusively IMO in MySql Sql commands structure

This is a single quote '      can be used for text or integer (but the server will convert it to integer if its numeric.  Basically its used as a delimeter and also to indicate literal meaning(it is what it is sort of thing) (it is recommended never use single quotes around  integer values)

This is a double quote "    pretty much used for text only IMO

There are times that its possible to confuse tilde's for single quotes if you dont look closely and pay attention.

Glor....  You can still do the change regardless if you have mariaDB or not.  Adding tilde's is not going to hurt anything.  Look at that link above from paul.  Look at the red and the green bars, the red bar is the old code (with out tilde's)  the green bar is the changed code (with tilde's) 

For example the first one...

it shows  as rows

change it to  as `rows`   (remember its a tilde NOT a single quote)  leave everything else the same including the single quote after it.

The red and green will show you the difference, its up to you to decide what has changed exactly and repeat it. 

Always use notepad or a actual code editor when editing code files (never open them with a text editor)

DO NOT EVER copy any code from the net (regardless how simple it is) and post it directly into your code file. Always post it into notepad or a code editor first.  There may be hidden values and putting them into a notepad or code editor first will remove those.  Then copy it from the notepad into your file.. Or just manually type the code.

Hope that helps you all...   :)