<option value="1">Apple</option>
<option value="2">Banana</option>
<option value="3">Cat</option>
<option value="4">Dog</option>
<option value="5">Elephant</option>

This is my query..

"select DISTINCT * from words where alphabet=1"

and It displays

1

Question: How can I display "Apple" ?

I've already tried that.. still no display.. I've also tried it on command line.. and the alphabet is value to 1..

Originally Posted by drkeni9ma

This is my query..



and It displays



Question: How can I display "Apple" ?

With what you have told us up to now ... the anwser is. ...









You can't.


HTML cannot query the database and return values of any kind.

@chrishirst why? even if I use a 'case' or if-statements?

What language are you using to query the database and what does the table structure look like. If you are using php or asp posting that code will help.

Originally Posted by drkeni9ma

@chrishirst why? even if I use a 'case' or if-statements?

Because HTML (this forum) has no scripting capabilities and cannot query a database.