Not sure if I should out this here or in the php forum, I have a question that's probably gonna include both SQL and php...
I'd like to add an image field to a table I have but I've never stored images in an SQL database before and I'm not sure how to go about it.
Ideally, what I would like to do is have the user be able to upload an image to the table and then later return the path of for that image.
Say, I store the image in the localhost directory, what I'd like to do is store that image in a table so that http://localhost/example.jpg is returned when the user searches for whatever is linked to that image in the SQL table.
If I were to list it out (cause that's how my brain works :D):
1. use is given option to upload image
2. image is stored in SQL table using appropriate query
3. user searches for something in table
4. result returns path of image
Basically I found a niffy little cover flow script that needs file paths for the images it uses. Mostly I'm stuck on how to best to store an image in an SQL table - the php and queries need to do that and then the query needed to return the images path. And really the select query will probably be self-explanatory once the insert query is clearer for me.
Thanks so much.