Right so just to ask if my theory is correct here, I have a database that lists characters from movies.
I want a search bar to help filter results, by default the table shows all the characters upon loading the page and eventually I will make the table a drop down sort of thing. So the characters appear in a table already, that's fine and what I want is when I search for a character for the table that the characters are currently listed in to character and populate with the search results.
The other option would be to direct to a new page to display the results. I can't seem to find anywhere that shows exactly how to do that and I'm fairly new to PHP, does anyone have any suggestions of pages/ videos that would help with this at all?