database pictures?

[slayerment]

how could i make it so when people search my database certain pictures come up with the results. ive got all my tables set up for certain things but i dont know how i would go about thumbnail pictures. i dont need to have the search for the pictures. i just want them to come up according to what item they go with. make sense? im using mySQL by the way. thanks!

[Bezzer]

I havn't done much with MySQL...but you would just use the data base the same way you usualy would...

if ur using PHP you would probably do some thing like this...


<img src="<?php echo $picname ?>" width="blah" height="blah">

Its the same as loading a usual image..only you echo the name of the image from the database...you would probably know how to do that...

Hope this helps :)

[slayerment]

ya i am using php too, but how would i store a picture on my database? ive never done this. thanks!

[Bezzer]

you would just store the address for the picture, not the actual picture. You could make it so that you have a file browser on your new post page. the file selected is uploaded, and the name is stored in something like "picture"...then with ur php you would do something like

<img src="folder/<?php echo $picture; ?>.jpg" height="40" width="40">

[IceCube]

actually.. theres another way too... you can store a binary element in the database using the col type: blob (binary large object) in which you can store pictures and files... though it makes the db slower and heavier... but it still works...

[slayerment]

i got it working. i put the img url on my db and do it that way. thx!

[Bezzer]

no problem :) i'm glad it helped :P