INSERT INTO cfc_news ([from], [date], title_gr, title_en, text_gr, text_en, image, [file], active, catid) VALUES('#FORM.from#', #FORM.date#, '#FORM.title_gr#', '#FORM.title_en#', '#FORM.text_gr#', '#FORM.text_en#', '#FORM.image#', '#FORM.file#', #FORM.active#, #catid#); SELECT * FROM cfc_news WHERE id = '#FORM.id#'; SELECT cfc_admin.username, cfc_admin.grouplevel, [cfc_news].[from] FROM cfc_admin, cfc_news WHERE cfc_admin.id LIKE '#GetData.from#'; SELECT id, grouplevel FROM cfc_admin WHERE id = '#session.loggedGRP#'; SELECT [image] FROM cfc_news WHERE id = #FORM.id#; SELECT [file] FROM cfc_news WHERE id = #FORM.id#; UPDATE cfc_news SET [from] = '#FORM.from#', [date] = #FORM.date#, title_gr = '#FORM.title_gr#', title_en = '#FORM.title_en#', text_gr = '#FORM.text_gr#', text_en = '#FORM.text_en#', image = '#FORM.image#', [file] = '#FORM.file#', active = #FORM.active#,catid=#FORM.catid# WHERE id = #FORM.id#; SELECT id FROM cfc_news WHERE id = '#URL.NPiD#'; DELETE FROM cfc_news WHERE id = '#URL.NPiD#'; DELETE FROM cfc_newscat WHERE id = #FORM.id#; <cfoutput>#Variables.Title#</cfoutput>