MySQL Forums
Forum List  »  Newbie

Help With Advanced Query
Posted by: Tom Smedley
Date: November 14, 2015 05:36AM

I have a current query, which is used to select holiday deals from a database. I want to edit it to ensure that, there is only one holiday displayed for:

1 Listing Per Hotel, Per Airport, Per Day

I'm unsure the best way of modifying my query?

Thanks In Advance!

Airport Field is 'outbounddepartureairport'
Hotel Field is 'hotelname'

SELECT *
FROM search_results
WHERE priceperadult < :price
AND expiry > ( NOW( ) - INTERVAL 1440 MINUTE )
AND outbounddepartureairport =:airport
AND expired <> 'expired'
AND outbounddeparture >= :startdate_full
AND outbounddeparture < :enddate_full
AND duration = :duration
AND holidayresort = :destination
ORDER BY $sort_query LIMIT 50

Options: ReplyQuote


Subject
Written By
Posted
Help With Advanced Query
November 14, 2015 05:36AM
November 14, 2015 11:39AM
November 14, 2015 11:51AM
November 14, 2015 09:49PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.