Hi there, I have tried lots of different ways to get what i want out of this query but i seem to be failng all the time and if anyone could PLEASE help me!!
I am trying to basically do a query that says if there are no events in the current month then please return a value of "no records" or display a different record with a different confirmed number? Which ever way i need to show that if there are no records related to the current month then it needs to show another record saying there are no records.
this is my current base query, that if in Date_Month there are no records, it just wont show anything. I need it to show a return somehow if there are no records available.
SELECT Date_Day AS 'Day', Circuit, Country_Name AS Country
WHERE Date_Month = month(now()) AND Confirmed = 1
ORDER BY Day
LIMIT 0, 100
I have tried, saying that if there are no records, then I want it to look for records with Confirmed= 2 as I have used that as one that lists "no records"
if anyone can help please!