How can i select and insert with one query?

[mohammad6006]

It is an example about SELECT from a table and INSERT to another table :

PHP Code:

INSERT INTO Customers (CustomerName, Country)
SELECT SupplierName, Country FROM Suppliers; 


How can I do that with VB DB class?

[kh99]

You just need to use query_write (like $vbulletin->db->query_write()) and pass it a string with sql you want to use.