quick SQL insert question - vb syntax ??

[rob30UK]

I need to run the following SQL via a plugin...

INSERT  INTO  `subscribeforum` (  `subscribeforumid` ,  `userid` ,  `forumid` ,  `emailupdate`  ) 
VALUES ( NULL , $userid,  '7',  '2'
);

What syntax would I use within the plugin code to perform the above as I understand VB has dataobjects I can tie into?

Thanks for help.

Originally Posted by rob30UK

I need to run the following SQL via a plugin...

INSERT  INTO  `subscribeforum` (  `subscribeforumid` ,  `userid` ,  `forumid` ,  `emailupdate`  ) 
VALUES ( NULL , $userid,  '7',  '2'
);

What syntax would I use within the plugin code to perform the above as I understand VB has dataobjects I can tie into?

Thanks for help.

PHP Code:


$vbulletin->db->query_write("INSERT  INTO `subscribeforum`
(`subscribeforumid` ,  `userid` ,  `forumid` ,  `emailupdate`  ) 
                                   VALUES ( NULL , $userid,  '7',  '2')
                          "); 


[Paul M]

You don't need those awful backwards quote characters though.

Originally Posted by Paul M

You don't need those awful backwards quote characters though.

hehe the backtick - that is usually generated by phpmyadmin....