Can anyone help me?
Today I was informed that the backend for my project will not be MySQL, but MSSQL 7.0.
No problems, I said, but after porting database from MySQL to MSSQL I find that the
UPDATE statement doesn't work. Strange is that INSERT statement in a php query does
not work second time (ie, i made a script for taking records from MySQL and insert in
MSSQL; first query work, but second doesn't).
Code is here:
my_update("update sometable set col1=".$var1." where col2=".$var2);
and function:
function my_update($query){
global $host,$user,$psw,$name;
$conn=mssql_pconnect($host,user,psw) or die("Error: connection failed!");
$rdb=mssql_select_db($name,$conn) or die("Error: DB does not exist");
$rez_q=mssql_query($query,$conn) or die("Error: Invalid SQL");
}
The same code and function work fine in MySQL. Why doesn't work in MSSQL Server???
Adrian JURJICA
================================
Tel.: +40-94-128879
E-mail: [EMAIL PROTECTED]
================================
Nu ocoliti pe Internet:
http://oneblackcat.f2s.com
http://www.terrasat.ro
http://www.transcondor.com
http://aimmr.go.ro
================================
