pb of Insertion

[pang]

hi,
i'm meeting a strage problem here is my code

include("connexion.php");
$sqlquery = "INSERT Arrete VALUES('$numarrete','$datearrete','$numbo','$datebo','$pagebo','$grade','$departement')";
$result=mssql_query($sqlquery) or die("impossible to execute the insert query");

mssql_close($sqlconnect);
mssql_free_result($result);

i'm the owner of my database where i have my table named Arrete, so i have all the autorisations.

i'm getting the message "impossible to execute the insert query" but when i check my table i find that the insertion is done. i'm not having this problem when i execute a SELECT query,
could anybody help me plze? thanks in advance

[Sxooter]

Mayhaps the MSSQL query returns 0 on a successful insert?

[pang]

thanks for reply sxooter
i've tried this:

include("connexion.php");
$sqlquery = "INSERT Arrete VALUES('$numarrete','$datearrete','$numbo','$datebo','$pagebo','$grade','$departement')";
$result=mssql_query($sqlquery);// or die("impossible executer la requete INSERT");
echo $result;
mssql_close($sqlconnect);
mssql_free_result($result);
include("menu.php");

but the insertion is done and i don't get the value of $result !!! what does is mean?

[Sxooter]

sounds like a bug in the mssql interface code. don't have a mssql server here to test it on. I'll ask a friend to try it out.

[pang]

Now i'm working without the die message, because when i write:

   

include("connexion.php");
$sqlquery = "INSERT Arrete VALUES('$numarrete','$datearrete','$numbo','$datebo','$pagebo','$grade','$departement','$observation')";
$result=mssql_query($sqlquery);//or die("impossible executer la requete INSERT");
// other instructions
mssql_close($sqlconnect);
mssql_free_result($result);

i get the message and it can't excute the instructions code after the insertion, so i delete the die("impossible....") but the problem is that i can never know if there is a problem of insertion.

[maxpup979]

I didn't run the insert through php--rather, I ran it in query analyzer-- and it seemed to work just fine. That would make me think that there may be an issue with php not catching an error properly?

But without a lot more details, Im not sure we can be of any further help. I am uncertain why it would throw an error to begin with--

[maxpup979]

Try altering your query to insert into arrete

adding the into keyword-- Im wondering if the mssq package is choking on that --

this is very strange