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

103
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

206
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

111
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

135