Inserting an array of values into database
I have an array of values (not associative) that I'd like to insert to the database. First, I thought that this simple line of code will do this for me:
But it didn't work.
I checked class.mysqldriver.php, function GetInsert and found what I know: when you have an associative array of FieldName => Value pairs, it works like a charm.
Quite a common case when you just have your values to be inserted and you don't want to specify column names like:
INSERT INTO tbl_name VALUES(myvalue1, myvalue2, ... , myvalueX);
I think the function should handle that.
How can I avoid to build an associative array of FieldName => Value pairs?