sql server - PHP inserting into mssql using odbc -


I enter form data in the table with this code in my user registration page

  $ Msquerys = "Username (Account, Password, Rank, Sausnow, Email, Block) value (''. $ Account. '', ''. $. Pass, '', ''. $ Rank. '', '123123-1231231', '"$ email ..",' "$ blockdata .. '')"; $ Msresultss = odbc_exec ($ conn2, $ msquerys) or die ('& lt; div align = "center" >  

Unfortunately I need to enter SOCNO 123123-1231231 with that hyphen, even when it does this The value is included in -1108108. It seems that PHP is looking at it as a subtraction and trying to insert it like this.

Enter (Account, Password, Rank, Sauce, E-mail, Block) Value (?,?,?,?,?,?) "); $ MSR Results = ODBC_XIX ($ MSqueries, Array ($ account, $ pass) , $ Rank, "123123-1231231", $ Email, $ blockdata) or die ('& lt; Div align = "center" & gt; & Lt; P align = "center" & gt; & Lt; Strong & gt; #################### Something went wrong, please get help! ########### & lt; / Strong> & Lt; / P & gt; & Lt; / Div & gt; ');

Comments