inserting multiple rows

[Anon]

hi

i have 3 arrays coming from flash > php > mysql.

i'd love some help with the syntax for a query to insert the arrays into multiple rows of the database along the lines of

insert into table fred values (?,?,?),(?,?,?),(?,?,?).......

for the length of the array.

i'm new (2 whole days) to php... my queries loop through the correct number of times, overwriting data with the next iteration of the loop. so i show the last array value.

any ideas?

thanks in advance, termy

[amcgrath]

You won't be able to do the multiple insert with one query. Loop through the array, and pass that generated query (with values from the loop) to the database. Seeing your code would help, too...

[[deleted]]

Not quite true. Some databases (like MySQL) let you insert more records at once using the method that Termy describes.

But I need to see his code to see what's wrong.

[amcgrath]

Learning something new, thanks V...

[[deleted]]

you're welcome.

but the fact that MYSQL supports it does not mean that it is a good idea to actually use it too.

[Anon]

thanks for your replies.

im not certain im doing the right thing here, throwing the values into a database. i am currently trying another option, writing the values to a text file.

which method do you suppose is the best for writing and reading a chunk of data? id like the arrays to be a hundred or so long...often i can't send it from the flash page (im using POST) and it's as little as 20(x4) objects. im doing this locally, windows, apache...

heres my appalling code!

option a

//using only one array to test...

$i=0;
while ($i < count($object_array))
{
$query = "insert into object
(object_name) values
('$object_array[$i]')"
;
$i++;
}

option b

//write to file

$filename = "data/test.txt";
$forflash = "object=".$object_name."&\nx=".$object_x."&\ny=".$object_y."&\nrgb=".$object_rgb;

$fp = fopen ($filename, "a+") or
die("couldnt open file");

fwrite($fp, $forflash);
fclose($fp);

once again thanks for your ideas.
termy

[Anon]

option a
all i had to do was put the

mysql_query($query) or
die(mysql_error());

after the increment $i++;

option b
my computer (browser? windows? who knows?)handles it now.

so now the remaining question is theoretically which is better to use option a or b??? cheers!

[[deleted]]

lol so all you forgot to do was actually run the query? :-)

textfiles are evil, the database always wins.

[Anon]

may as well have, i ran the query outside the loop...duh!

cheers vincent, database it is...