Search function

Posted on 16th Feb 2014 07:03 pm by admin

I am looking for some guidance from the experts.

I am trying to create a search function. It will only be searching one table. The search criteria consists of two drop down menus. Each menu lists the available options for a specific column in the table. So if someone chooses an option from both menus, the search would display the results that match both options in a row in the table. If they choose one, and leave the other blank, it will only display matches for the one choice. I think that's a good explanation.

Anyways, I've got the html side of things taken care of, but I have no idea how to go about getting the results I'm looking for. This is a bit more complicated than inserting, editing, or deletng data from the database. Those things I can handle.

Someone help a brother out who is looking to dig deeper into PHP.

Your Answer:

Login to answer

Other forums

isset undefined variable
Hi all,

Hope someone can point out the obvious. I've a log in script, if you dont enter a use

Send inserts to mysql thru port 80
Hi!

I have an application that must do some inserts in a mysql db. This db is behind a firewa

php sessions,logouts & the bloomin back button!
Hi All,

I've got a cms that members can log into. When they logout, the session is destroyed,

Help with parsing this html
Hi,
I've got some html i just need a couple of strings from.. argh, it's freaking me out. I've t

Sending CC Info by email
I am a little bit less knowledgable in the security area as most developers and I know I have a lot

Chat Box in PHP
I was thinking in doing a Chat Box in PHP. For that I would use a form with two fields, Nick and Mes

Problem Dereferencing
With these types and tables:

CREATE TYPE MANAGER AS OBJECT (
MGR_ID INTEGER,

PHP Surveys
I really would like some advice.

If you have a client come to you asking for a survey to be d

Passing PHP variables from one page to another
Hello-

I'm having trouble figuring out how to transport a variable from one php file to anoth

Problem with passing variables
I'm not really a php programmer so I'm really struggling with this issue.

I have a banner s