Hi guys Basically I'm totally new to php and I need a drop down list which will show the lowest price of whiskey. In a numerical order, I have made many efforts within my database, but I have not been successful. Help will be greatly appreciated Even I have done so far.
& lt ;! DOCTYPE html & gt; & Lt; Html & gt; & Lt ;? Php is required ('config.php'); & Lt; Body & gt; & Lt; Select & gt; Enter code here & lt; Option value = "lowest price" & gt; Lowest price & lt; / Option & gt; & Lt; Option value = "highest value" & gt; Highest price & lt; / Options & gt; & Lt; / Select & gt; & Lt; / Body & gt; & Lt; / Html & gt; ? & Gt;
Actually there is something like that;
$ query = 'Selection ID, by value ASC from the table order name' $ result = mysqli_query ($ link, $ query); $ Rows = mysqli_fetch_array ($ result, MYSQLI_ASSOC); & Lt; Select & gt; Enter code here & lt ;? Php foreach ($ lines as $ line) {echo "option" = "". $ Line ['id']. '' 'Gt; $ ['Name']. "& Lt; / option & gt;"; }? & Gt; & Lt; / Select & gt; Keeping in mind that you are using mysqli (I hope you do), and procedural PHP.