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 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 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 Link to comment https://forums.phpfreaks.com/topic/184124-sql-command/#findComment-972138 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.