Stupid Syntax Error
Posted: Wed May 11, 2005 3:25 am
This is a really simple syntax error that I cant figure out and its driving me nuts!
What is the difference between
AND
The first one runs correctly but the second snippet returns this error
Not my eyes it should be the same but I am still a bit green to PHP.
I need to split the line out so the next stage of development is running multiple lines into the insert via a loop.
TIA
Hengis
What is the difference between
Code: Select all
$userid = $rї'fld_int_id'];
$sql = "e;INSERT into tbl_projPeop (fld_int_PersonID, fld_str_Project) Values ('$userid','P1234')"e;;Code: Select all
$userid = $rї'fld_int_id'];
$sql = "e;INSERT into tbl_projPeop (fld_int_PersonID, fld_str_Project) Values"e;;
$sql = $sql + "e;('$userid' ,'P1234')"e;;Code: Select all
Warning: odbc_exec(): SQL error: їMicrosoft]їODBC SQL Server Driver]їSQL Server]Line 1: Incorrect syntax near '1'., SQL state 37000 in SQLExecDirect in C:\Inetpub\tikiwiki\iain\index2.php on line 26I need to split the line out so the next stage of development is running multiple lines into the insert via a loop.
TIA
Hengis