Print Page - Mysql help with uploading pics.

Title: Mysql help with uploading pics.
Post by: twave on February 03, 2004, 11:51:22 AM

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

Title: Mysql help with uploading pics.
Post by: Joachim Müller on February 03, 2004, 11:28:25 PM

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

coppermine-gallery.com/forum

Support => Older/other versions => cpg1.2 Standalone Support => Topic started by: twave on February 03, 2004, 11:51:22 AM