Mysql help with uploading pics.

[twave]

Hi

Im trying to get the filepath and filename combined into a seperate new field in the mysql database (cpg11d_pictures) when either:

1) photos are batch loaded or
2) via single upload.

so that i can view pictures that has been uploaded in say album=5 in another php file in my website using a recordset, repeat region and filter in dreamweaver.  

eg  filepath = userpics/whats_on/
     filename = latest.jpg

and to add my files path =/coppermine/

result in a new field = /coppermine/userpics/whats_on/latest.jpg

Any ideas?  This would allow me to upload pics to an album and they dynamically update on a whats_on php page.  

If i am going about this the wrong way please help?  I am so close just need the data to input into mysql.

Many Thanks

[Joachim Müller]

there's already a path info in the existing mySQL structure - no need the add an extra field with excess (garbage) info. Just write your query on the whats_on.php page correctly, no need to mess with the tables...

GauGau