Re: [PHP] sytax errors

[Mark Rees]

John Nichel [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
 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
 [EMAIL PROTECTED]

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] sytax errors

[babu]

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 [EMAIL PROTECTED] 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
[EMAIL PROTECTED]

-- 
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

Re: [PHP] sytax errors

[Raz]

 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.
 
No - there is no problem with any of the statements per se, but there
may be when executed with $adduser, $addpass etc. Why not take the
advice of Mark Rees and echo the $sqlstmt etc and show us the output?

Raz

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: [PHP] sytax errors

[John Nichel]

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
[EMAIL PROTECTED]

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php