How to display image from mysql

[philipwayne]

I'd say you'd need to add a "color" field to the MySQL table otherwise you'd have to do some pretty hardcore hacking on the images to get there overall color. Then just use a WHERE cause in the SQL "WHERE `color`='red'".

[selvasoft]

I have color field in my database. but i don't know how can i retrieve that values in my combo box.

Thank you

[selvasoft]

Please help me. I have color field in my database but i don't know how can i retrieve that colors in my combo box.
give any idea to me.

Thank you

[Atli]

It's fairly simple. You query the database for the colors, loop through them, and print each color as an <option> for your <select> box. - If you read through any one of the literally hundreds of beginner PHP/MySQL tutorials out there, this should be no problem.

Try it. If you run into problems, post them here. (With proper explanations!)

[selvasoft]

Ok thank you for your help. i will try that.