I am trying to make ODBC connection to Access 2000 database and insert record from form info. Can someone tell me what is wrong with this code:
<?
require_once 'DB.php';
require_once 'config.php';
$dsn = $DB_dbType . "://"
. $DB_dbName;
$db = DB::connect($dsn, TRUE);
if (DB::isError($db)) {
die($db->getMessage());
}
$sql = "Insert Into Leads(name,coappname,city,state,address,zipcode.homephone,workphone,typeofhouse,currentvalue,purchaseprice,mortgagebalance,interestrate,fixedoradjustable,monthlypayment,behindinpayments,selfrating,placeofemployment,yearswithemployer,yearlyincome,besttimetocall,loanamountdesired,typeofloandesired,emailaddress)
VALUES (<?$POST(name)?>,<?$POST(coapp)?>,<?$POST(city)?>,<?$POST(state)?>,<?$POST(address)?>,<?$POST(zip)?>,<?$POST(homephone)?>,<?$POST(workphone)?>,<?$POST(housetype)?>,<?$POST(currentvalue)?>,<?$POST(purchaseprice)?>,<?$POST(balance)?>,<?$POST(rate)?>*100,<?$POST(fora)?>,<?$POST(payment)?>,<?$POST(behind)?>,<?$POST(rating)?>,<?$POST(employment)?>,<?$POST(years)?>,<?$POST(income)?>,<?$POST(time)?>,<?$POST(desired)?>,<?$POST(loantype)?>,<?$POST(email)?>";
$result = $db->query($sql);
if (DB::isError($result)) {
die ($result->getMessage());}
$db->disconnect();
?>
