query select from table where price is < or >

[jamesreno20]

hi im trying to use  query to select from a table where the price is between to values that the user has to input such as min of 3 and max of 8 and return all the fields from the database where it is true im unsure how to do this but this is what i have so far

 

$res = pg_query ($conn, "SELECT ref,artist,composer,genre,title,album,label,price,description FROM music WHERE price = < && > ");

echo "<table border='1'>";

echo "<tr><th>Select</th><th>Artist</th><th>Composer</th><th>Genre</th><th>Title</th><th>Album</th><th>Label</th><th>Price</th><th>Description</th></tr>";

[Ch0cu3r]

Add each less than or greater than condition separately. Example

SELECT ref,artist,composer,genre,title,album,label,price,description FROM music WHERE price >= 3 AND price <= 8

Or use a BETWEEN clause

SELECT ref,artist,composer,genre,title,album,label,price,description FROM music WHERE price BETWEEN 3 AND 8

[jamesreno20]

 

Add each less than or greater than condition separately. Example

SELECT ref,artist,composer,genre,title,album,label,price,description FROM music WHERE price >= 3 AND price <= 8

Or use a BETWEEN clause

SELECT ref,artist,composer,genre,title,album,label,price,description FROM music WHERE price BETWEEN 3 AND 8

 

i need the numbers to be input from the user do you know how to do this

[Ch0cu3r]

First check to make sure the min and max inputs are numbers then place the variables inplace of 3 and 8 in your query. Preferably using a prepared query