database pictures?

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!

No, you don't make sense. You say you don't want to have a search engine for the pictures, but then you say you want them to come up according to what item they go with. Can you be much more specific?

i want to know how to have pictures come up with my database results. would i just put the pictures on my database too? i dont know how to do this.

use photoshop and make us a flow chart. it might make things alot easier.

if you don't know what a flow chart is, google it, but it'd probably be alot easier for us to understand you with one.

I think I understand you. Store you images in a directory named /images or whatever you design. Then have a column for the image file name. Then for each row in your database put an image file name and it will come up with your results.

because its too time consuming to teach you...let me give you my code...

create the table images...like this

CREATE TABLE images (id int(10) unsigned NOT NULL auto_increment, name char(25) NOT NULL, size int(10) NOT NULL, PRIMARY KEY (id)
);

here is the query to insert the image name.

mysql_query("INSERT INTO images (name,size) VALUES ('filename','sizeoffile')");
echo "The picture has been inserted into the database."
";

if you are still lost tell me

a little old ;)

i don't even think he needs it anymore, heh :p

yeh i got it working, thanks everyone