hi . i have been struggling with a problem with file uploads and mysql for a while on and off and have recently dug out my php bible to learn some more 🙂
i figured out, after a lot of reading and hours of trial and error, how to use a html form to upload text and file paths into a mysql database. im a relative newbie, so ive not had time yet to try everything out. my problem is when i use <input type=file> i save the path to an image etc that i have uploaded in a mysql db, but if i want to change any of the text data within my form i cannot keep the image path in the db, but i have to browse for the image again or it will be a broken link?
<font face="Verdana, Arial, Helvetica, sans-serif" size="2" color="#000000"> >> Browse for pic - <input type="file" name="image"></font>
<input type="submit" name="add_image" value="upload details">
i am aware that there maybe gallery software floating about that can do this but i`m hoping for a simpler solution. i only do this as it is a challenge for myself any pointers would be greatly appreciated 🙂