I am trying to display my products from my database using two conditions:
1) show products with a product ID (prod_id) between 1000 and 4000.
2) only show those products where the variable "current" equals "yes".
Below is what I currently have and it gives me an error:
$query = "SELECT * FROM inventory WHERE current=='yes' AND prod_id BETWEEN 1000 AND 4000 ORDER BY description";
Oh, and I also need to show the results alphabetically (ORDER BY description). Can anybody tell me what I'm doing wrong? Thank you.
🙁
