I am a beginner and would appreciate help on this small project where I use php (in fact PHPRunner) with an Access database.
I receive the error "Parse error: syntax error, unexpected 'CustomQuery' (T_STRING)..." with the code below. What would be the correct syntax?
$sql= "INSERT INTO ItensVistorias ( IDVisitoria, Descricao, Ord ) SELECT ApoioAddItensVistorias.ApoioA, ApoioAddItensVistorias.Descricao, ApoioAddItensVistorias.Ord FROM ApoioAddItensVistorias;"
Any indication on where I could find samples of sql statements for PHP x Access would also be appreciated.
Thanks in advance,