[RESOLVED] Is it possible to add an array directly into a table?

[haynest]

Hey guys. I have been doing some thinking and am trying to find a shortcut. I have an array that I would like to add directly to my db. This array contains 122 - 125 string values. My data base will have 125 fields. Is there a way to insert the array into mysql without doing the obvious which would be to make a single insert query that would name all of the fields and then somehow make a foreach to loop through the individual elements of the array? I will make some code to show you to.

$fields = explode("\t", $record);
//separates each tab separated value in array $record and puts it in $fields

//Time to insert into database
$query = "INSERT INTO residential(//definitely do not want to declare 125 fields here) VALUES(//$fields array)";
$result = mysql_query($query); //Run the query.

Is this possible? Thanks.

[nemonoman]

This pretty easy: You'll have to set up your code to do an 'extended' insert:

INSERT INTO account VALUES
(1, 'Ad Credit Card Sale', 1.000),
(2, 'Affiliate Sale', 3.000),
(3, 'Service Charge', 150.000),
(4, 'Credit Card Fee', 100.000)

change your arrays to fit the extended insert format.

Note commas for each batch of data but the last.
Note that your DATA ELEMENTS must PRECISELY LINE UP with your table definition.
In other words:

If you have 3 columns:
INSERT INTO account VALUES
(1, 'Ad Credit Card Sale', 1.000),
(2, 'Affiliate Sale', 3.000)

Will work

INSERT INTO account VALUES
(1, 'Ad Credit Card Sale'),
(2, 'Affiliate Sale')

Will fail.

You can manage a null value 2 ways:

INSERT INTO account VALUES
(1, 'Ad Credit Card Sale', ''),
(2, 'Affiliate Sale', NULL)