Hi guys, I have a problem with php_mssql function. I've already installed freetds for the odbc and php4.0.3pl1 in linux box. Now, I can connect to Ms_sql7.0 and do a SELECT query. But Why I cannot make other query like INSERT, UPDATE etc. In Ms-sql, I've already give all the permissions to the user, but it's still unsuccessful.
I write the code like this:
$result=mssql_query("INSERT into $tablename values('xxx','xxx')");
the result is nothing.
The problem is:
1.Why I can't use other query command except SELECT ?
2.Where is the mistake, how should i suppose to do with php and ms-sql?
3.Is there any example code for this problem?
This thing makes me crazy, cos till now i cann't solve this problem, i've already try lots of way but still unsuccess.
is there any body who can help me to solve this problem, cos i really need this solution for my final assignment.
For all of you who can help me, I really thank you in advance.
Techzoo
I write the code like this:
$result=mssql_query("INSERT into $tablename values('xxx','xxx')");
the result is nothing.
The problem is:
1.Why I can't use other query command except SELECT ?
2.Where is the mistake, how should i suppose to do with php and ms-sql?
3.Is there any example code for this problem?
This thing makes me crazy, cos till now i cann't solve this problem, i've already try lots of way but still unsuccess.
is there any body who can help me to solve this problem, cos i really need this solution for my final assignment.
For all of you who can help me, I really thank you in advance.
Techzoo