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

JSON SORT WITH PHP
I have two products that I want to sort by say "Id:17, value: xxx" using php
The page w

Question about ShowWindow()
Hello....

I'm struggling with sumpin, and I hope y'all can help.

I've got a CFormView

Adding to an Int row in db
Hi, i have a database which houses all of the users of my site. One of the columns is for points whi

problem with query error
First Thanks to those who helped me on my previous posts, and the following code i'm using is not mi

An odd assignment statement. Can someone explain this assignment to me?
What purpose is served by the bit of code between the two equal signs in the $installurl set? Is th

Need help Updating SQL Server Express DB from c# :(
Please can anyone help with:-
1 How to sructure the strSelect statement.
2 How to instruct

str_replace help
Hey there,

I'm a PHP newb, I'm having troubles with the str_replace function. I want to clean

TimeStamp Column Problem...
I'm mad at my self and thinking I'm a little retarded. It just be some one mistake I'm missing here.

how to remove in php string display
My code is $message="We're looking at developing our website."; $body= "My mess

Internal Server Error issues
This has been bothering me for weeks and I've been trying to solve it without asking for help, but e