Mysql help with uploading pics. Mysql help with uploading pics.
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

Mysql help with uploading pics.

Started by twave, February 03, 2004, 11:51:22 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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