"John Nichel" <john@xxxxxxxxxxxx> wrote in message news:42DBDB89.4050207@xxxxxxxxxxxxxxx > 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? Is it a php or mysql syntax error? If the latter, please echo $sqlstmt etc and show us the output > > -- > 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