Jump to content

Proper syntax for WHERE in query...


CorkyMcDoogle

Recommended Posts

Hello...

I'm trying to set up a way to sort database results by the type of article it is. I have links Show: Type1 - Type2 - Type3 - All. The single type links work correctly but when I want to show all of them together nothing comes back. It's because the syntax I'm using is not correct I'm guessing.

Whats the correct way to ask for multiple types in the WHERE?

[code]switch ($_GET['type']){
case 'type1':
$type = "type1";
break;
case 'type2':
$type = "type2";
break;
case 'type3':
$type = "type3";
break;
case 'typ4':
$type = "type4";
break;
case 'all':
$type = "type1,type2,type3,type4";
break;
}
}
else {
$type = "type1";
}


$query = "SELECT DISTINCT type, title, itemtext, DATE_FORMAT(postdate,'%b %D, %Y - %l:%i %p') AS postdate FROM item WHERE type = ('$type') ORDER BY rand() LIMIT 10";[/code]
Link to comment
https://forums.phpfreaks.com/topic/17041-proper-syntax-for-where-in-query/
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.