Re: Interbase INSERTION error?

>>hey all.. >> >>I really don't get why I am getting this error.. Can somebody help me >>out? what does a parse error mean? >>Error: >>Parse error: parse error in /home/httpd/html/test/php-test/CVzenden.php >>on line 35 >> >>CVzenden.php: >> >>$conn=ibase_connect("localhost:/home/httpd/html/test/php-test/CV.gdb", >>"SYSDBA", "masterkey"); >> >>if (!$conn) { >> echo "Accesso Denied! $back"; >> exit; >> >> } >> >>$query="insert into PERSOON values >>('0','$TITELVOOR','$ROEPNAAM','$VOORNAAM','$INITIALEN','$TUSSENVOEG','$ACHTERNAAM', >>'$TITELACHTER','$GESLACHT','$BURGSTAAT','$GEBOORTEDATUM','$GEBOORTEPLAATS','$NATIONALITEIT','$STRAAT','$HUISNR', >>'$POSTCODE','$PLAATSNAAM','$PROVINCIE','$LAND','$TELPRIVE','$TELWERK','$MOBIEL','$FAX','$BESCHIKBAAR','$EMAIL','NOW','NOW');"; >>$result=ibase_query($conn,$query); >> if (!$result) { >> echo "Error. Can't insert the record with the query: $query! >> $back"; >> exit; >> } >> echo "<br><br>Record saved: $name $back"; >> ibase_close($conn); ?> You forgot to tell Interbase into which fields te values should be inserted. Example: $query="insert into PERSOON(roepnaam,achternaam) values($ROEPNAAM,$ACHTERNAAM);