1. u want to display types of fruits2. u have a table for receipt of your fruiti still can't get what u want to get ? the information given is rather blur.>The idea I have is having a dropdown menu with different variables to search for (color, shape, size, etc.), then a text feild next to the dropdown menu in which someone could submit a keyword to search by. So, say you had a red fruit. In the dropdown menu, you could set it to "Color" and then in the search field, type in the word "Red" then hit submit. At this point it would go and look for all matches in the database that would match the Color=Red search, then display it back on your page in a nice table, with each matching result's Name, Recipe, Color, etc.>Now that's the idea ~ how do I turn the idea into a functioning page? And is there a fairly simple way for me to lay all this information out without having to enter line after line of mySQL commands to get the data into the tables I'd need, such as a GUI interface?i think u should create something like this:1- the search page (could be php or htm)2- the post page (this should be php)3. the display page (inserted by post page)in the search page you can each dropdown will have it own id and valuesuch as id=color value=color, id=shape value=shape .. etcduring the post pageu have to insert the value into sql query ============================ex:$wheris = $_post("selectwhere");$wheris2 = $_post("theselect");if (whereis2 == blank) { $wherenya = "";} else { $wherenya = "where " . $wheris . " = " . $wheris2;}$sql = "select * from fruit $wherenya";go on ==============================that's maybe the solution u may need.danke Oncom BeureumThe Best Place in The City