Loop? Question

[jarla]

A new problem again. I have a page where my customer can download pictures with his (or her) username. I´ve wrote a cfm -page which handles database connection. It writes down username, date and the picturename(s). If the user downloads more than one picture, how can I add every of them on different database line? Now my program adds every picturename to the same column. Example:

Date Pictures Username
02-14-2001 pic1,pic2,pic3 user
---------------------------------------------
I want it like this:
Date
02-14-2001 Pictures Username
pic1 user
pic2
pic3
---------------------------------------------
Thank you!

 

[iza]

instead of a &quot;,&quot; append a &quot;<br>&quot; ??
or if ot's more of a sql problem, insert 3 times instead of 1 ...

 

[jarla]

Here is my code, which inserts picturenames to database:

<cfquery datasource=&quot;datasourcename&quot; name=&quot;insert&quot;>
INSERT INTO downloads (date, picture, username)
VALUES (#Now()# , '#form.picturename#', '#form.username#')
</cfquery>

Is that right and how must I change it that it puts every picturename to different column like I told on my first message?

 

[iza]

your query looks good, with it you'll get :

Date Picture Username
02-14-2001 pic1 user
02-14-2001 pic2 user
02-14-2001 pic3 user

(if you repeat it 3 times, changing only the picture name)

sounds like it's what you waned to have, right ?

 

[PDL]

Is your picture a jpg/gif file?? How do you move the image into the database?