First off, I'm no programmer. To make matters worse, I'm new to WordPress. That said, I need to have the front page search query only a table I created (nowhere else) and only return certain items. I made an HTML page that gets the job done, but I switched to WordPress and wanted the front page search to do the same thing. Here's what I have:

The table I put in (say, table1) has 9 fields. I need the search to match the "ID" field and return firstname, lastname, expiration, and validation - meaning if the expiration date is equal to or before the current date it would return "Valid", otherwise it would return "Invalid".

I'm using another template, I don't know if that matters as I will use the basic search.

Here is the template in case anything is needed from it: http://charles.dnsalias.com/theme1.zip

I have searched everywhere, but nothing I have found fits, or I can't modify it to work for me. Any help would be greatly appreciated.