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 - [EMAIL PROTECTED]
|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" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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);
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
