[PHP-DB] SQL unexpected T_CONSTANT_ENCAPSED_STRING Error

Thu, 22 Mar 2007 05:15:31 -0800 

Hi All,
   
  I have a sql script unable to execute. Because I need to insert double-coats 
( " ) also to one field(SPParams field).
   
  Ones I execuit this using mysql_query($sql), it gives "Parse error: parse 
error, unexpected T_CONSTANT_ENCAPSED_STRING " error message.
   
   
     $strSql = "";
   $strSql = $strSql."UPDATE Masters.tblBranches SET FHeadMail= '[EMAIL 
PROTECTED];', ";
   $strSql = $strSql."BranchDBConnection='Server=SLBC05; Database=BackOffice; 
UID=b0;pwd=sSLap.+05);', ";
   $strSql = $strSql."SPParams='<pl><ipl><p id="spCustomersAddSLBC" 
t="VarChar">CustomerName</p><p id="spCustomersAddSLBC" 
t="TinyInt">CustomerType</p>' ";   
   $strSql = $strSql."WHERE BranchCode=101";
   
  How can I be able to solve this issue..?
   
   
  Thank you very much,
  Lasitha

                
---------------------------------
 What kind of emailer are you? Find out today - get a free analysis of your 
email personality. Take the quiz at the Yahoo! Mail Championship.

Reply via email to