Search & Result pages

Hi,

I have created a PHP page with a dynamically populated selection list and submit button. And another php page that is suppose to display the results in a table from MySQL.

But haven't got the code quite right.

Does anyone know some good tutorials for building search and results pages in PHP?

 

Maybe you could share the code and we'll try to improve it.

 

I wish I could but I can't because it's an assignment and I could get into trouble.

Basically, what I have is a page with a form and then another page that is suppose to display the results.

I can't seem to find too much info. on this on the web.

 

Which part are you up to? I will give pointers but need to know if you are stuck at making the form, setting up the DB getting the form data into the database with PHP or retrieving data from the database.

 

I'm stuck on the results.php page.

On the search.php page I have a dynamically populated search list - linked to a table but there's a option called "Any" which if selected will retrieve all of the options within the selection list. But I need it to retrieve the result if only 1 of the options is selected also.

 

Also another problem is that the options are represented by a number in another column of the table in MySQL, and I have to also link that to the options in the selection list.

 

From what I understand you will have to use something like a check box. Can you be more clear?

 

I already got a selection list (otherwise known as a drop box)...