Some mysql queries are not working. Any solution please

[Meokkoma (Me Okke)]

I want to update views.

UPDATE Students SET views = views + 1 WHERE id = 2

I am using above query. That is not working

…

Lastly I found what is the problem.
‘+’ marks are not pass true query. Anyone know solution for that ?

[Rogerio_Rios (Professional Support)]

What does “not working” mean? Nothing happened ? Or some error was shown? Where did you run this Query? Via blocks or directly in the script? By the way, this is Kodular Community, maybe you can get help faster if you use Google…

[Meokkoma (Me Okke)]

It coming error. I am use the mysql.php script
Same error result coming from both

these sql queries are worked on phpmyadmin. but not in app

[Rogerio_Rios (Professional Support)]

How to get the return of the Run_Mysql Query method - Deep Host extension

the solution is to NOT use the Deep Host extension, there is no support anyway see also Taifun

[Meokkoma (Me Okke)]

Lastly I found what is the problem.
‘+’ marks are not pass true query. Anyone know solution for that ?

[TimAi2 (metricrat)]

You may need to escape the + like this \+, or use additional punctuation - '+' or "+" ?

[Taifun]

@Meokkoma

‘+’ marks are not pass true query

how does the query arrive on the php side?
did you try my solution here App Inventor Tutorials and Examples: MySQL | Pura Vida Apps, which UriEncodes the query?

Taifun

[Meokkoma (Me Okke)]

Lastly it succeeded. The solution is use the Uri Encode for only query.

Thanks for all replies