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

Why is my row count 0?
Here's the MySQL query i'm running. It basically pulls data from 2 tables based on some data passed.

Gantt Chart Tool
Does anyone know of a good free gantt chart creator tool

Thanks

How many users online in the last 24-hours using time()?
I'm fairly new to PHP. I have a MySQL table called 'users' and a field called 'loggedin' which is in

Sequre login with cookies.
I want to build secure login with cookies. I just want your ideas about this, your suggestions. What

Take info from one coloum and move to another
Hi all,

I have this:
Code: [Select]$array = "SELECT stock_id FROM stocks WHERE stock_

Oracle11g Patch issue
Hi all,

I'm getting the following error while installing Oracle11g Patch 11.1.0.7.0 on IBM-AI

displaying email without attracting a ton of spam
Hello,

this is maybe the wrong place to ask.
How would you display an email address on a w

Estimations and Effort
HI Gurus,

Would like to know whether SAP have a provision for carrying out the Project es

Keeping data in form
How can I keep whatever I write in the form?

Career Change into SAP
Hai
I am sajesh ,did my diploma in Mechatronics i have a 4 years of experience in