Re: Arduino UPDATE Mysql

[Darci CIdade]

I made this form but it did not work:

char query_4[80];
int port_relay4 = 9;

void loop() {

int val = digitalRead (port_relay4);

if (val == LOW)

sprintf(query_4, "update minhacas_a.usuario1 SET posicao = 0 where id_rele = 1;");
}
else
{

sprintf(query_4, "update minhacas_a.usuario1 SET posicao = 1 where id_rele = 1;");
}