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

Sql and php order list script problems
Hi im having a few problems with trying to get the coding right on a orders list ive done (or trying

Warning message
I've put a website that I was doing live and I'm getting this warning message when I try to add a ne

Add a sign-up feature to a flat file login script
I'm working on a flat file login script and I would like to add a sign-up feature to it with a email

Removing Title From database problem
Hi again ! i am having an issue with updating database. When i update any price of a title it remove

values in array being escaped
I would like to submit some values - back to the same form for checking before processing...

need help about
i store the value of my select statement result to an array and stored it to a variable named $fname

PHP webpage & array print issue
I have this code running, and it works perfectly … however, see my bottom bit about what I see

Help with some dates
I have a list of dates in an array:

$mondays = array(
strtotime("October 12, 2009

Having a problem get the selected item from a drop down menu
I have been looking at this for days now.

I have a drop down menu that get it's values from a

Multiple Dropdown Selections
I have a form that let's a user insert a page with the ability to select categories. I want them to