fetch multiple data from database table to select query

Question

fetch multiple row data from database table.

 

i create select query to fetch data. below is my code

 

  $query = "SELECT * FROM diamond_tbl WHERE price BETWEEN '".$_POST["minimum_range"]."' AND '".$_POST["maximum_range"]."' ORDER BY price ASC";