Adding image with text in select box using php/mysql

Asked Nov 03 '12 at 12:03

Active Nov 03 '12 at 12:10

Viewed 806 times

    <? 
    ... 
    mysql cnx code 
    ... 

    $sql="SELECT id, thing FROM table"; 
    $result=mysql_query($sql); 

    $options=""; 

    while ($row=mysql_fetch_array($result)) { 

        $id=$row["id"]; 
        $thing=$row["thing"]; 
        $options.="<OPTION VALUE=\"$id\">".$thing; 
    } 
    ?> 

... 
html code 
... 

<SELECT NAME=thing> 
<OPTION VALUE=0>Choose 
<?=$options?> 
</SELECT>

I'm using the above code to generate a drop down from my mysql database, but i also want an image in front of every text in the drop down list.

For example: I have 4 things - APPLE, MANGO, BANANA, CARROT and the images are stored in a folder and their path is saved in a database table field. All i want to do is to add the respective image along with the text.

Thanks in advance

edited Nov 03 '12 at 12:10

Matteus Hemström

3,796
2
26
34

asked Nov 03 '12 at 12:03

user1731476

http://stackoverflow.com/questions/2965971/how-to-add-a-images-in-select-list – A.B. Nov 03 '12 at 12:17
tag, doesn't support / Allows the HTML script inside. So you cant display the images as option of the drop down. instead, you can use jquery div based dropdowns. – Prasath Albert Nov 03 '12 at 12:17
@PrasathAlbert I'm aware of that, I also know that i need to use div to do that, but unable to do it. – user1731476 Nov 03 '12 at 12:19
@HasanTahsin I tried that too but its not working. – user1731476 Nov 03 '12 at 12:26

Adding image with text in select box using php/mysql

0 Answers0