I am trying to make query where a user enters a date range to check for events [on hold]

95
September 06, 2017, at 6:33 PM
SELECT      event.event_name, event.start_date, event.end_date, event.all_year, event.yearly_natural 
FROM        event 
INNER JOIN  event_location ON event_location.event_location_id = event.event_location_id
WHERE       (event.yearly_natural = false 
            AND
            (
                event.start_date BETWEEN '$testFrom' AND '$testTo') 
                OR (event.end_date BETWEEN '$testFrom' AND '$testTo') 
                OR (event.start_date <= '$testFrom' AND event.end_date >= '$testTo')
            )    
            OR (event.yearly_natural = true
            AND
            (
                DATE_FORMAT(event.start_date, '%m%d') BETWEEN '$testFrom' AND '$testTo')
                OR  (DATE_FORMAT(event.end_date, '%m%d') BETWEEN '$testFrom' AND '$testTo')
                OR (DATE_FORMAT(event.start_date, '%m%d') <= '$testFrom' AND event.end_date >= '$testTo')
            )  
            OR (event.all_year = true)
READ ALSO
NotWritableException Can&#39;t write image data to path

NotWritableException Can't write image data to path

How to store an avatar correctly

166
How to send message from WhatsApp in PHP with WhatsAPI Official? Didn&#39;t get password

How to send message from WhatsApp in PHP with WhatsAPI Official? Didn't get password

I'm working on Whatsapp API message codeBut I'm not able to get my Whatsapp Password

104
Nested Loop in Eloquent in Laravel

Nested Loop in Eloquent in Laravel

I am having trouble with my codeI have two tables Stocks and StockLists however, I want to get all the related stock in the stocks list based on the stock code

126