[SOLVED] WHERE clause

[dude753]

Hey,

 

I've looked and looked but I just can't find anywhere which says how to do this.

 

Here's my query. I want it to show info from just 2 specific categorys, not any of the other possible categories. Here's one of the variations I tried:

$sql="SELECT * FROM `values` WHERE `name` LIKE '%".$q."%' AND `category` = 'normal_rares' OR 'seasonal_rares' ORDER BY `rd` DESC LIMIT 15";

I also tried:

$sql="SELECT * FROM `values` WHERE `name` LIKE '%".$q."%' AND `category` = 'normal_rares' OR `category` =  'seasonal_rares' ORDER BY `rd` DESC LIMIT 15";

 

I can't seem to get this to work.

 

Any ideas?

 

Thanks

[richardw]

try this, group the values, but your statement needed another field name in the OR

 

<?php 
$sql="SELECT * FROM `values` WHERE (`name` LIKE '%".$q."%') AND   (`category` = 'normal_rares' OR  `category` = 'seasonal_rares' ORDER BY `rd` DESC LIMIT 15";?>

 

Hope this works... 

[fenway]

Missing close paren before the order by clause...

[richardw]

Thanks for catching the error!