insert data from arrays into db

[vocoder]

i have some data in arrays that i need to loop through and insert each item into a db...

for ($i=0; $i < count($body_array); $i++)
{
	$testsql = "INSERT INTO mytable (date, body, href, source) VALUES ('$date_array[$i]', '$body_array[$i]', '$href_array[$i]', '$news_array[$i]')";
	$result3 = mysql_query($testsql) or die ('error message goes here');
}

the above code does not work. So my question would be....I guess my logic is wrong, heh..but how do I go about doing this?

[lemon8]

I'm no PHP guru, but I've used the exact code you posted above before and it's worked just fine for me. Maybe I'm missing some detail but it should work fine.

Are you sure your arrays are filled?

[vocoder]

yeah i figured out what the problem was.....i have a date field and the date i am trying to pass to it is not in the correct format, so i'm guessing that is screwing things up. fixed it and now it works.