connect(); if (isset($_GET["sortby"])) { switch ($_GET["sortby"]) { // Add cases for "rating", "priceHighToLow", and "priceLowToHigh"// ... case "rating": $query = "SELECT * FROM Products Order By rating"; break; case "priceHighToLow": $query = "SELECT * FROM Products Order By price DESC"; break; case "priceLowToHigh": $query = "SELECT * FROM Products Order By price ASC"; break; case "": $query = "SELECT * FROM Products"; break; default: $query = "SELECT * FROM Products"; break; } $result = $con->prepare($query); $result->execute(); $row_count = $result->rowCount(); $res = $result->fetchAll(); for ($i=0; $i<$row_count; $i++) { $rating = ""; $stock = ""; for ($j=0; $j < $res[$i]["rating"]; $j++) { $rating .= "*"; } if ($res[$i]["stock"] > 0) { $stock = "In Stock"; } else { $stock = "Out of Stock"; } //echo($res[$i]["price"]); echo( '

Name: '.$res[$i]["name"].' Rating: '.$rating.'
Price: '.$res[$i]["price"].'
Stock: '.$stock.'

'.$res[$i]["description"].'

'); } } ?>