matchoo Posted September 13, 2007 Share Posted September 13, 2007 Hey there, I am using MySQL 5.1 I have an HTML grid of 16 different images. Each image has an img_type. I want to return exactly 16, with img_type prioritized as follows: If there are 16 img_type = 'people' I want to return them all If there are less than 16 img_type = 'people' I want to return as many as possible, and populate the rest with img_type = 'other' Again, I need exactly 16 images, but comprised of different types based on how many 'people' are in the database. Is this possible using CASE statements? If so, I would love a little help and a generic example. Thanks. -Matt Link to comment https://forums.phpfreaks.com/topic/69159-conditional-query-help/ Share on other sites More sharing options...
effigy Posted September 13, 2007 Share Posted September 13, 2007 SELECT * FROM table ORDER BY IF(type='people', 0, 1) LIMIT 16 Link to comment https://forums.phpfreaks.com/topic/69159-conditional-query-help/#findComment-347725 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.