Jump to content

Archived

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

CorkyMcDoogle

Proper syntax for WHERE in query...

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]

Share this post


Link to post
Share on other sites
SELECT * FROM table WHERE fieldname = 'text';

or

SELECT * FROM table WHERE fieldname LIKE '%text%';

Hope this helps

Share this post


Link to post
Share on other sites
Yea but I'm trying to get multiple types into one WHERE.

If type is set to 'all' I want it to show all types. Something like...
[code]WHERE type = 'type1 OR type2 OR type3 OR type4'[/code]

How can I make what I want fit into the $type variable?

Share this post


Link to post
Share on other sites
[code]WHERE type = 'type1' OR type = 'type2' OR type = 'type3' etc.[/code]
or
[code]WHERE type IN ('type1','type2','type3','type4')[/code]

Share this post


Link to post
Share on other sites

×

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.