Hi, Its giving the line number. But actually i want to know the correct syntax for concatenation. I think all there is some mistake in all the three concatination statements. so could some one check and give some idea. thanks John Nichel <john@xxxxxxxxxxxx> wrote: babu wrote: > Hi, > > could someone please check where the sytax error is in these statements. > > $sqlstmt= "EXEC sp_addlogin ".$adduser." , ".$addpass; > $sqlstmt1= "EXEC sp_adduser @loginame= ".$adduser." , @name_in_db= ".$adduser; > $sqlstmt2= "GRANT CREATE TABLE TO ".$adduser; > $sql=mssql_query($sqlstmt); > $sql1=mssql_query($sqlstmt1); > $sql2=mssql_query($sqlstmt2); Didn't php give you a line number? -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 john@xxxxxxxxxxxx -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php --------------------------------- Yahoo! Messenger NEW - crystal clear PC to PCcalling worldwide with voicemail