chwebdesigns Posted December 5, 2009 Share Posted December 5, 2009 Hi, I don't have a lot of experience with mySQL and SQL commands. Here is my command on which I am working on: $sql = "SELECT * from shop_products where subcat='$cat' order by id asc"; This part of the code works fine. However I want to include to WHERE parts in the sql statement. I have tried this, however I come up with an error saying that it cannot execute the query: $sql = "SELECT * from shop_products where subcat='$cat' where shown='1' order by id asc Any ideas would be appreciated. Many thanks Quote Link to comment https://forums.phpfreaks.com/topic/184124-sql-command/ Share on other sites More sharing options...
rajivgonsalves Posted December 5, 2009 Share Posted December 5, 2009 you should use and $sql = "SELECT * from shop_products where subcat='$cat' and shown='1' order by id asc Quote Link to comment https://forums.phpfreaks.com/topic/184124-sql-command/#findComment-972136 Share on other sites More sharing options...
chwebdesigns Posted December 5, 2009 Author Share Posted December 5, 2009 Many thanks, Just what I needed Quote Link to comment https://forums.phpfreaks.com/topic/184124-sql-command/#findComment-972138 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.