Help with PHP pictures in mysql
Posted: Wed May 27, 2009 12:19 pm
Hey all,
OKay so I finally have my search function working using PHP and mysql!! take a look here: http://stevenspraguememorialrun.com/search.php JUST TYPE "31" in the bib field. As you can see after you type 31 you get a page with all the results for that Bib as well as a picture with the person in it. I achieved this by adding another column to my mysql table called "image" then typed in "<img src="/racepics/DSC_0014.jpg" into that specific row.
It works beautifully, the problem is I need to do this with over 300 people!! I cannot sit there and manually enter each image file name into the correct participants data field.
Does anyone have any suggestions? I did take the liberty of tagging each photo's metadata with the appropriate bib number.
Also something to note: some participants are in more than one photo. I don't know if that would change anything.
Thank you so much!!!
OKay so I finally have my search function working using PHP and mysql!! take a look here: http://stevenspraguememorialrun.com/search.php JUST TYPE "31" in the bib field. As you can see after you type 31 you get a page with all the results for that Bib as well as a picture with the person in it. I achieved this by adding another column to my mysql table called "image" then typed in "<img src="/racepics/DSC_0014.jpg" into that specific row.
It works beautifully, the problem is I need to do this with over 300 people!! I cannot sit there and manually enter each image file name into the correct participants data field.
Does anyone have any suggestions? I did take the liberty of tagging each photo's metadata with the appropriate bib number.
Also something to note: some participants are in more than one photo. I don't know if that would change anything.
Thank you so much!!!