Need help with search scripting
Posted on 2006-11-11
So ... now I have to learn PHP (can't use CGI) and database management. I have no problem accessing the database and managing records, and I have no problem connecting to the database with scripts, but I am just learning how to query and return results.
I have been pulling my hair out for a week trying to figure out the following:
I have three independent searches on one page. Each search was designed tol call a separate page. On this same page, there are two text searches, one specific and one open. I need to be able to have success at the simplest text search (open) first before I can move on to the other text search and the drop down menu search.
My first query needs to result in three fields being extracted from the database table. In this case it is town, number, and sub_number. The results need to return on a page in rows (unlimited) but each row hyperlinked. These hyperlinks will be links to internal HTML pages. That's it. I just need to know the proper query syntax and code. If I can make this work, then I will have a better understanding about how to progress further, especially trying to succeed with the other searches on the page. Do I need to use a parse.php page, or is it better just to have the database connection info on each page.
In any case, I have been working an entire week testing scripts and wasting lots of time and getting frustrated. Desperate for help. Thanks in advance.