sql command

[chwebdesigns]

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

 

[rajivgonsalves]

you should use and

 

$sql = "SELECT * from shop_products where subcat='$cat' and shown='1' order by id asc

[chwebdesigns]

Many thanks,

 

Just what I needed