I searched the forums to no avail so if there is a previous post that covers this please let me know.
---
I am querying numbers from a database and am having a little trouble. At the moment I am able to query numbers (1, 2, 3) but when it comes to the length of numbers that's where it's not coming through (1 vs. 10 vs. 100). So when a user requests the lowest price accepted for a house (100,000) and maximum price (1,000,000) this returns everything you can think of (example: 10,000,000 and 10).
Here is a portion of my query below:
Code:
mls_listings.price >= '{$_GET['minprice']}' AND
mls_listings.price <= '{$_GET['maxprice']}'
mls_listings.price is the table containing the price
minprice and max price is exactly as sounds coming from a drop down menu that the user has selected before arriving to this page.
---
Thank you for your help
