I build a ACCESS 97 named addcard.mdb database，on a host supporting access2003，with only one table named cardregist. There are
c_pro,c_cit,c_name,c_url,c_mail,c_intro,c_addr,c_prom 8 collumns in the table
I submit data throug a form with inputs named pro,cit,name,url,mail,intro,addr,prom
but when I submit data throuth the form . I get error message on the web。
Can anyone help?
<?php
include('tohtml.inc.php'); // load code common to ADODB
include('adodb.inc.php'); // load code common to ADODB
$db = &ADONewConnection("access");
if ($submit == "sub") {
$start_trans = odbc_autocommit($dd,1);
msg(suceed)
}
This is my newest data submitting page
$access = 'addcard.mdb';
$myDSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;'.'DATA SOURCE='. $access . ';';.'USER ID=cardmem;PASSWORD=bi@oj3fulU;';
$sql = "insert into cardregist (c_pro,c_cit,c_name,c_url,c_mail,c_intro,c_addr,c_prom) ";
$sql .= "values ('$pro','$cit','$name','$url','$mail','$intro','$addr','$prom')";
$conn->debug = true;
if ($conn->Execute($sql) === false) print 'error inserting';
?>
