hello
PHPmaker 2017
Status :
table : fach2018 -> fields : eventname |start|end | proj_id| (eventname,start,end are already filled)
table : projects -> fileds : projectname |start|end |proj_id
So in table fach2018 the proj_id field is a lookup from projects incl. add new project
I need to copy from table fach2018 -> eventname to projects->projectname and start - end when select ADD
in table projects : row updating ???
$MyResult = ew_Execute("INSERT INTO projects (projectname, start, end) SELECT eventname, start, end FROM fach2018 WHERE MyField=XXX");
I dont get the condition...
THX a lot