Mysql Insert, Auto Insert?

Question

$insert = mysql_query ( "INSERT INTO analise VALUES ( $analise_hora )" ) ;

I am trying to insert this data with this function automatically when the user enters the page, but it is not being inserted, my time variable is right I gave an echo to test, my connection to the database is ok.

Wasn’t supposed to send automatic with just this one insert ?

Answer 1

If you have more than one field in this table, the error happens if it is not set in which field you want to insert.

INSERT INTO analise (nome_campo) VALUES ( $analise_hora )