Select (drop down) Menu Query

chefmars

I have a MySql table (meat) storing the results data of on online culinary exam. One of the fields in the record is "optype". It is a drop down select field with about 12 choices.

I have a separate results page, and when a user goes to that URL the results are displayed automatically. I am currently displaying the results of the MySql table (meat) using the following query:: $query = "SELECT * FROM meat WHERE optype='Country_Club'ORDER BY time DESC";

What I would like to do is let the user decide, from a drop down menu, the various options that are available for optype. Country_Club is just of the 12 choices, others being Hotel, Educational_Facility, etc.

What I am after is a way to allow one user to display the results using the query$query = "SELECT FROM meat WHERE optype='Country_Club'ORDER BY time DESC"; and another user to display the results using the query $query = "SELECT FROM meat WHERE optype='Hotel'ORDER BY time DESC"; .... and so on

Can anyone lend me some help?

Regards,

Chef Mars

Vbabiy

So you want to dispaly the result from that query in an drop down menu? Right

chefmars

Thanks for the interest.

I want to give the user options for determining what the results of the query are for the following part of the query call optype='Country_Club'. When a user takes the exam they pick from the drop down menu what their hospitality operation type is and that piece of information is inserted as part of the record into the table (field name is optype).

I would like a user to be able to pick which optype they want to see the results of, using a drop down select menu, then submit the form and return a result page. The optype options would mirror the same ones available to persons taking the exam. I have all worked out except the changing of the optype='????' part of it and hope it is possible.

I hope I am being clear.

Regards,

Chef Mars

Vbabiy

Can you post some code i am still not gettng what you need

harmor

let's say the name of your drop down menu is optype (<select name='optype'>)

So in your query put

$query = "SELECT * FROM meat WHERE optype=' ".$_POST['optype']." ' ORDER BY time DESC";

Vbabiy

That whats what i though he ment but wasnt sure

chefmars

harmor wrote:
let's say the name of your drop down menu is optype (<select name='optype'>)

So in your query put
$query = "SELECT * FROM meat WHERE optype=' ".$_POST['optype']." ' ORDER BY time DESC"; 

Harmor,
I would like to thank you very much for the help, and also Vbabiy.
I will use the code you so generously passed on to me and let you know the results.

I doubt if I could ever help you with any PHP or MySql issues but when it comes to the culinary arts, most likely I can, so please do not hesitate to ask.

Regards,

Chef Mars
mars@marscafe.com

Vbabiy

Thanks for the offer... How about some free food 🙂