Update query to update data in mysql

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

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

Yes both id and view is set to big int

And table name is test

But it’s also not working

Check at 2nd line

Yes Test is the table name

Test I know it’s case sensitive

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.


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

And here is the blocks

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

It’s 100% working in app also broo

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

In update query

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

Any way I have found the reason for the issue

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

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.