I am trying to get my db query to work. The table referenced has 6 elements per record, the four variables called which are 0 or 1 TINYINT values and an id (auto inc primary key) and a TIMESTAMP. I want to use the four variables I'm trying to retrieve in the python code. I've done the webform that allows update of the database (and I have learned that queries in python and PHP are not that similar). So I want to check the db every 30 seconds and load the last entry. As a minor point the lines at the end that close the db were creating an error saying connection already closed so I just commented them out ATM.Any help is greatly appreciated.
I didn't find the right solution from the internet.
Creative infographic design studio