AdRock Posted September 29, 2007 Share Posted September 29, 2007 I am trying to create some search criteria and I have just written a SQL query and would like to know if it is valid SELECT * FROM table WHERE price BETWEEN min_price AND max_price, bedrooms => min_bedrooms, location = location, type = type, keyword LIKE %description% I haven't tested it becuase I have no data to test it with but the theory looks good to me Quote Link to comment https://forums.phpfreaks.com/topic/71193-is-this-a-valid-mysql-query/ Share on other sites More sharing options...
Barand Posted September 29, 2007 Share Posted September 29, 2007 No, it isn't valid. Many years I came across a useful technique. I think the technical name for it is "experimentation". Set up some test data, because if it weren't so obviously wrong, that's what you'd be expecting us to do. Quote Link to comment https://forums.phpfreaks.com/topic/71193-is-this-a-valid-mysql-query/#findComment-358114 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.