Help for this page

Select Code to Download


  1. or download this
    #Taking the values one at a time, and assigning to variables
    $DOBYear = $ayDOB_Year[$i];
    ...
    
    #Concatonating the string
    $ODBCDate = sprintf("%4d-%02d-%02d", $DOBYear, $DOBMonth, $DOBDay);
    
  2. or download this
    $sqlInsert = "Insert into tblMaster (List_Name_, Gender_, First_Name_,
    + Last_Name_, Full_Name_, Address_1_, City_, State_, Zip_Code_, SCF_Co
    +de_, Country_, Email_, Domain_Name_, TLD_, DOB_) Values ('$ListName',
    +'$Gender','$FirstName','$LastName','$FullName','$Address','$City','$S
    +tate','$Postal','$SCF','$Country', '$Email','$DomainName','$TLD', cas
    +t('$ODBCDate' as datetime))";