I have insert statement:
$SQLinsert = "INSERT INTO $Table (UserID, ID, Title, Body) VALUES ('$($result.userId)','$($result.id)', '$($result.title)', '$($result.completed)');
But it is importing only one record. Now I have $result as an array and want to insert all the values with one INSERT statement.
SQL should look like this: INSERT INTO Table (UserID, ID, Title, Body) VALUES (1, 2, Test1, Test2), (2, 3, Test3, Test4)
But cant think of how to format the INSERT sql statement with multiple rows.