incubator140

$city ='city1, city2, city3'; $newCity = str_replace(',', "', '", $city); $sql = "select * from test where city in ('$newstr')"; This is working for me..

Hi, Please try the following: $city ='city1, city2, city3'; $newCity = str_replace(',', "', '", $city); echo $newCity;

hi, When i tried to restore DB using SQL Server 2005, am getting errors as follows. TITLE: Microsoft SQL Server Management Studio ------------------------------ Restore failed for Server 'INC133'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ The backup set holds a backup of a database other than the existing 'LenderDetails' database. RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3154) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=3154&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Can anyone help me? Thank, Bindi.