I have a table (say "testtable") as below which I read into PHP:
I have a form called "testform". On this are two text boxes, one called "textbox" and the other called "textanswer".
I'm trying to type a number into "textbox", get it to look up this number on the ID field of the table mentioned above and put the corresponding colour into "textanswer".
Usually I would do this by having "textbox" set up as a dropdown field and pull the second column into "textanswer" when changed. However, in this case I can't do this because if a colour is not found on the table, the user needs to be able to type in their own value in "textbox". Also, there will be some 15000 records in the table.
Can someone please show me how to set this up, if possible?
Many thanks in advance