Code: Select all
Let>MySQLTable=PostContent
Let>MySQLServer=xxx.xxx.xx.xx
Let>MySQLPort=3306
Let>MySQLUser=username
Let>MySQLPassword=password
Let>MySQLDatabase=databasename
Let>ODBCDriver=MySQL ODBC 5.3 Unicode Driver
Let>MySQLPort=3306
Let>ConnectionString=Driver{%ODBCDriver%};Server=%MySQLServer%;Port=%MySQLPort%;Database=%MySQLDatabase%;Uid=%MySQLUser%;Pwd=%MySQLPassword%;
Let>SQLCmd=INSERT INTO %MySQLTable% (title,image1,image1_link,image1_description,image2,image2_link,image2_description,image3,image3_link,image3_description,image4,image4_link,image4_description,tags,published,account) values ("%Title%","%Image1SRC%","%ImageLink1%","%Description1%","%Image2SRC%","%ImageLink2%","%Description2%","%Image3SRC%","%ImageLink3%","%Description3%","%Image4SRC%","%ImageLink4%","%Description4%","%Tag%","%Published%","%Account%")
DBConnect>ConnectionString,dbH
DBExec>dbH,SQLCmd,result
DBClose>dbH