Please can somebody help me !
I'm just trying to make an insert on my database but it doesn't work .
Actually only the select command works.
Here is the message error i get :
Warning: SQL error: [Microsoft][Pilote ODBC Microsoft Access] L'op閞ation doit utiliser une requ阾e qui peut 阾re mise ?jour., SQL state S1000 in SQLExecDirect in C:\php3\objet.php on line 9
which means:" the operation must use a query which can be updated"
my table golfeur(id_golfeur,fisrtn,lastn)
here is my code :
$connection=odbc_connect("golf2"," "," ");
// echo "$connection \n";
$requete1="select nom,prenom from golfeur";
$requete2="insert into golfeur values(10,'fabio','hero')";
// echo "mon delete va se lancer";
$result=odbc_exec($connection,$requete2);
PLEASE HELP
I'm just trying to make an insert on my database but it doesn't work .
Actually only the select command works.
Here is the message error i get :
Warning: SQL error: [Microsoft][Pilote ODBC Microsoft Access] L'op閞ation doit utiliser une requ阾e qui peut 阾re mise ?jour., SQL state S1000 in SQLExecDirect in C:\php3\objet.php on line 9
which means:" the operation must use a query which can be updated"
my table golfeur(id_golfeur,fisrtn,lastn)
here is my code :
$connection=odbc_connect("golf2"," "," ");
// echo "$connection \n";
$requete1="select nom,prenom from golfeur";
$requete2="insert into golfeur values(10,'fabio','hero')";
// echo "mon delete va se lancer";
$result=odbc_exec($connection,$requete2);
PLEASE HELP