'how to add multiple column values data into one datalist and attach to input field in php codeigniter

i have an input field and a datalist is attached to it.

<input list="bookrecords" autocomplete="off" size="45" id="searchOption" name="searchOption" style="text-transform: uppercase" type="text"  class="form-control" required="required">
                <datalist id="bookrecords">
                
                </datalist>

i have following query as below so that i can put the data into datalist.

"select DISTINCT author,publisher,bookname from bookdetails"

I want to add all the data of author,publisher,booknames into above datalist, so that it will make a single list and when i type into input box then it should sort from that specific list irrespective of its bookname,author or publisher. It should sort according to the words i keep typing.

I say sorry as i am not aware of how to write question , so apologies for bad writing Waiting for reply Thanks in advance



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source