Update query to update data in mysql

[CJcorp (Asit)]

I am using this query but not working

1. UPDATE Test SET View=‘1’ WHERE id=‘1’;
2. UPDATE Test SET View=1 WHERE id=1;
3. UPDATE Test SET View=1 WHERE id=1;
4. UPDATE Test SET View=‘1’ WHERE id=‘1’;
5. UPDATE Test SET View = ‘1’ WHERE id = ‘1’;

And much more but result is

[Rogerio_Rios (Professional Support)]

Field View is numeric ?
The table name is ‘Test’ ?
Id field is numeric field ?

[CJcorp (Asit)]

Yes both id and view is set to big int

And table name is test

[CJcorp (Asit)]

But it’s also not working

Check at 2nd line

[CJcorp (Asit)]

Yes Test is the table name

Test I know it’s case sensitive

[Taifun]

are you using any php script on your server?
is any other query working together with your script together with your MariaDB?

It would really help if you provided a screenshot of your relevant blocks, so we can see what you are trying to do, and where the problem may be.

To get an image of your blocks, right click in the Blocks Editor and select “Download Blocks as Image”. You might want to use an image editor to crop etc. if required. Then post it here in the community.

Taifun

[CJcorp (Asit)]

Not using any other PHP script except one is given by you to work with mysql

And here is the blocks

[CJcorp (Asit)]

Yes it is working on php my admin webpage but not from the app

[hemantadahalofficial (Neo Developer)]

It’s 100% working in app also broo

[hemantadahalofficial (Neo Developer)]

U faced problem when u update any query or with insert, select also u face the same problem?

[CJcorp (Asit)]

In update query

[hemantadahalofficial (Neo Developer)]

M not getting any issue or problem kindly check ur colms catgry

[CJcorp (Asit)]

Any way I have found the reason for the issue

Which is I was using textbox.colour instead of testbox.text