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... with data from form don't work...
// 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','$price')";
// prepare SQL statement
//$sql_prepare = odbc_prepare($connect,$sql) or die("Couldn't prepare
query.");
// prepare SQL statement
$sql_result = odbc_prepare($connect,$sql) or die("Couldn't prepare query.");
// execute SQL statement and get results
odbc_execute($sql_result) or die("Couldn't execute statement1.");
odbc_free_result($sql_result);
odbc_close($connect);
--
PHP Windows 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]
