Dear all,
I am trying to create a page with search fields to bring information from a simple database (in excel?) without showing the full excel database, but I am new to WP & am not sure where to start. Could not find such plug-in.
Here goes:
- I have an excel database of let's say Cats information (with headers(: column A "Cat ID", column B "Location", column C "Cat Color"
- I want my page to have two search fields:
> line one says "Check location of cat #" +[search field] + search button,
> line two displays nothing at first, and once search is hit, displays results this way: IF no result "There is 0 cat with this Cat ID number", IF result "Cat number xxx is located in Location"
>line three says "check how many with this color have been identified" + [color field] + search button
>Line four displays nothing at first, and once search is hit, displays results this way: IF 1 cat "There is 1 Color cat registered", IF 0 or more than 1: "There are O (or)N (bring total of matching records) Color cats registered".
Any tip/idea to satrt from would be more than welcome.
Many thanks in advance,