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

Connect to database that isn't localhost
I am currently doing a small script for a company that doesn't have mySql support on there hosting.

Not showing whole name with mail () script
I sent up a simple mail form with the PHP mail() script. One problem is when it sends an email with

PHP Upload issue
Hi guys,

I have stumble across an interesting issue with my script and is doing my head in.

Database 'Validation'
Hi everyone,
I'm trying to validate the password entered by the user with the password in the dat

how can i expire the submitted page using session.
hi,
i'm new to php world.
i'm using "post" method.
when i submit it,data goes to

Multiple server callbacks (NOT POSTBACKS)
Hello, I have 2 different javascript client side functions that are on timers. When the timers elap

Linking with Foreign Keys
I have been getting an erro when I try and link:

create table Faculty_Specialty (I_Name v

gather checkbox data from form into email
Hello all,

First, i'd like to thank everyone who responded to my previous posts regarding set

Hyperlink in PHP to MySQL record
Hello,

I am having trouble as i am new to php. I have connected to the database and I have di

using variables in another page
I have a test database set up on localhost. I have a form that I can type a name into, hit the butto