php/sql query syntax
Posted on 2008-10-07
Hello, i am running joomla 1.0.15, using fabrik 1.0.6, a form building component for Joomla, it gives the option of having the form perfom a php command - eq an sql query upon submission.
I was wondering if you could give me the proper structure for such a command
this is a sample sql query which I have run successfully from phpmyadmin
INSERT IGNORE INTO `jos_users` ( `name`,`username`)
(SELECT namel_newsletter,email_newsletter FROM `jos_fabrik_formdata_1` )
I know I need to add something like
but I`m not sure of the exact syntax.
Any help would be greatly appreciated