Re: Re: Interbase INSERTION error?

Technically, he shouldn't have to list the fields he is inserting into if he is inserting into the fields in order. Unless that's some funky Interbase requirement. A parse error is usually a PHP syntactical error. Can you post the whole of line "35" so we can see? :) ---------------------------------------------------------------------------- ----------- Sean Finkel - alarion@planetunreal.com |H|eretik - Pain in the ass for Clan |H|avoc - http://www.webdrenalin.com/ubbcgi/ Webmaster - Rabid Wolf .:: Food For Your Brain ::. - http://www.rabid-wolf.com Lead Programmer - Data Admin and Data Lib - http://dadmin.sourceforge.net ---------------------------------------------------------------------------- ----------- ----- Original Message ----- From: "Walter van der Velden" <Walter@thrijswijk.nl> To: <php-db@lists.php.net> Sent: Wednesday, March 14, 2001 2:29 PM Subject: [PHP-DB] 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','$ACHTE RNAAM', >>'$TITELACHTER','$GESLACHT','$BURGSTAAT','$GEBOORTEDATUM','$GEBOORTEPLAATS' ,'$NATIONALITEIT','$STRAAT','$HUISNR', >>'$POSTCODE','$PLAATSNAAM','$PROVINCIE','$LAND','$TELPRIVE','$TELWERK','$MO BIEL','$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);