Jump to content

sql command


chwebdesigns

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.