hi
i have error when i want to insert data to Database(ms-Access)
please guide me!!
warning is :
insert into TblDarman values(ihpbpihb,’’,’’,’’,’’)
Warning: odbc_do() [function.odbc-do]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1., SQL state 07001 in SQLExecDirect in F:Project site ExpertDarmanToseeDarman1.php on line 23
Source is:
<?php if(!strlen(trim($_GET['txt1']))) { echo "123"; die(); } $connectionstring = odbc_connect("Darman", "",""); $query ="insert into TblDarman values("; $query = $query.$_GET['txt1'].","; $query = $query."'".$_GET['txt2']."',"; $query = $query."'".$_GET['txt3']."',"; $query = $query."'".$_GET['txt4']."',"; $query = $query."'".$_GET['txt5']."')"; echo $query; $result = odbc_do($connectionstring, $query); odbc_close($connectionstring); ?>thank u!