Trouble adding multiple values to DB

[micmac]

Hi all,
Can't seem to find out why the following wont work.

for ($i = 0; $i < $UPLOAD_NUM; $i++)
{
echo "$name[$i]<br>";
$insert_article_uploads = "INSERT INTO knowledgebase_uploads (knowledge_article_id, knowledge_upload_path) VALUES ('$running_id','$name[$i]')";
}

I'm creating a multiple file upload script. I can successfully upload the files but i am having trouble writing the multiple file names to the mysql database, i can't even add one at the moment.
You will notice the echo statement, the weird thing is this actually echos the correct results, just won't add the name to the DB.
I will add that it is adding the knowledge_article_id value successfully.
Any ideas,
micmac

[nemonoman]

JUst to check the obvious: at some point are you saying connecting to the db and saying

mysql_query($insert_article_uploads);

?

[micmac]

I am, i am doing it outside of the for statement....would that make a difference?

Cheers,
micmac

[micmac]

i guess it would.

[Tekime]

Post an example of $insert_article_uploads and the results of mysql_error when it fails.