|
|
Posted by Bob Bedford on 10/08/07 13:15
HI all,
in my sql table I've a list of colors: white, blue, green.....
table colors
idcolor, coloname
1, white
2, blue
3, green.....
I've some programs sending colors for some material, but I don't want to use
them, I'd like to use my values:
example:
program gives 'dark blue' then I'd like to select blue in my table and
return 2...
how to do so ?
Thanks for replying.
Navigation:
[Reply to this message]
|