Hey Guys, i have a statement problem.. i don't know, how put on this correctly..
$fdata = "INSERT INTO `asd`.`qwe` (`name`,`lname`,`email`,`note`) VALUES (" & _
"'" & $sName & "'," & _
"'" & $sLname & "'," & _
"'" & $sEmail & "'," & _
;~ If StringInStr($ctrl, "'") Then
;~ If StringInStr($val, ",") Then
;~ "'" & StringSplit($val, ',', $STR_ENTIRESPLIT)[1] & "');"
;~ Else
;~ "'" & $val & "');"
;~ EndIf
;~ Else
;~ "'" $empty "');"
;~ EndIf
_MySQL_Real_Query($cnn, $fdata)
i'll be so much grateful..
*****************************************
Solution..
$fdata = "INSERT INTO `asd`.`qwe` (`name`,`lname`,`email`,`note`) VALUES (" & _
;~ db col - name
"'" & $sName & "'," & _
;~ db col - lname
"'" & $sLname & "'," & _
;~ db col - email
"'" & $sEmail & "',"
;~ db col - note
If StringInStr($ctrl, "'") Then
If StringInStr($val, ",") Then
$fdata = $fdata & "'" & StringSplit($val, ',', $STR_ENTIRESPLIT)[1] & "');"
Else
$fdata = $fdata & "'" & $val & "');"
EndIf
Else
$fdata = $fdata & "'" & $empty & "');"
EndIf
_MySQL_Real_Query($cnn, $fdata)
maybe it helps someone..