#32271 [Opn->Bgs]: Can not deal with symbol such as ' or " or \

ID: 32271 Updated by: derick@php.net Reported By: kangtk at 163 dot com -Status: Open +Status: Bogus Bug Type: MSSQL related Operating System: windowXP PHP Version: 4.3.9 New Comment: Sorry, but your problem does not imply a bug in PHP itself. For a list of more appropriate places to ask for help using PHP, please visit http://www.php.net/support.php as this bug system is not the appropriate forum for asking support questions. Even if you think it is not a bug, we often know better than you, please consult the support channels first before even considering to reopen this report. Thank you for your interest in PHP. . Previous Comments: ------------------------------------------------------------------------ [2005-03-11 03:32:30] kangtk at 163 dot com Description: ------------ I use PHP with sql server 2000 databse. when I use like this: $query = "select * from userinfo where Name='".$name."'"; $result = mssql_query($query,$db); But if the $name has the symbol such as ' or " or \,It will be error. Such as $name = " 'name" "; How can I deal with this? Thanks. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=32271&edit=1