dietkinnie Posted July 3, 2009 Share Posted July 3, 2009 Hi Everyone, I am stuck , and would like some inspiration I am trying this sql but not getting the correct result. case when max(price) and product_order = 1 then shelf_id end What i need is the shelf_id of the book with the highest price and has a product order of 1. p.S this is just a small part of the query.... I have really run out of ideas, so any tips would be greatly appreciated. Thanks in advance. //DK Link to comment https://forums.phpfreaks.com/topic/164682-case-max/ Share on other sites More sharing options...
BMurtagh Posted July 3, 2009 Share Posted July 3, 2009 Hey, By going off your post, I think you would need a SQL query along the lines of: SELECT shelf_id WHERE MAX(price) AND product_order = '1' FROM table_name This should at least put you in the right direction to get going. Also, you may want to check out http://www.w3schools.com/sql/default.asp for some additional resources. Link to comment https://forums.phpfreaks.com/topic/164682-case-max/#findComment-868504 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.