Re: [PHP-WIN] simple odbc/insert problem

2001-08-20 Thread LondonVibe
i think my post should have gone. " I know Nothing" :) the original code was from a select script which works... i thought is was as simple as changing the select for insert doh ;)... the var's from the form are all strings and they do reach the script... i'm just not sure of the code to

RE: [PHP-WIN] simple odbc/insert problem

2001-08-20 Thread Erik H. Mathy
> thx erik... i missed the first one (comment)... still get > error... Couldn't > execute statement1 third not sure on the odbc_exec.. OK, I must be brain dead this morning. ;) - original code - // connect to system dsn odbc name login and password or die $connect = odbc_connect("DB

Re: [PHP-WIN] simple odbc/insert problem

2001-08-20 Thread LondonVibe
"Erik H. Mathy" <[EMAIL PROTECTED]> wrote in message 001d01c1298a$c45958e0$1300020a@erik_laptop">news:001d01c1298a$c45958e0$1300020a@erik_laptop... > > new to php so be nice :) > > Always! ;) > > > win2k iis5.ms access.. > > Check... > > > // connect to system dsn odbc name login and pass

RE: [PHP-WIN] simple odbc/insert problem

2001-08-20 Thread Erik H. Mathy
> new to php so be nice :) Always! ;) > win2k iis5.ms access.. Check... > // connect to system dsn odbc name login and password or die > $connect = odbc_connect("DB","name","pword") or die (" not connected"); > > $sql="INSERT INTO basket (Item,Amount,Price) Values > ('$id','$amount','$

[PHP-WIN] simple odbc/insert problem

2001-08-20 Thread LondonVibe
new to php so be nice :) win2k iis5.ms access.. what is the order for adding var's to a access DB ?? i can read data form the DB ok.. even print it out in a nice table :)... but not sure how i write to the DB... it's driving me mad... any help or faq's would be cool... code i tried... w