Re: [PHP3] INSERT

Use this: Insert into YourDB (field1,filed3,field9)values(value1,value3,value9); instead of Insert into YourDB values(value1,value3,value9); Regards Durrani Lubos Pechacek <louise_konf@volny.cz> wrote in message news:392D026C.4C55A1FB@volny.cz... hi *, i need to INSERT some data from form into db through odbc. there are some fields in my form that are not required and that's the problem. if someone fills out my form and skip some fields nothing will be inserted in my db. how should i make the script to insert all data and instead of not filled fields insert empty item into my db (MS Access 97)? thanx Louise -- PHP 3 Mailing List <http://www.php.net/> To unsubscribe, send an empty message to php3-unsubscribe@lists.php.net To subscribe to the digest, e-mail: php3-digest-subscribe@lists.php.net To search the mailing list archive, go to: http://www.php.net/mailsearch.php3 To contact the list administrators, e-mail: php-list-admin@lists.php.net