[RESOLVED] Next event

zzz

I have a table with the following cells:

id
eventName
dateNumber
monthNumber

e.g.

| 2 | Some Event | 23 | 6 |

Some Event on June 23. I need to write a query to pick the next event listed in this table.

SELECT eventName
FROM t1
WHERE monthNumber => MONTH()
SELECT 1

Does that look right?

leatherback

you are now looking for all the messages in the month which is omre than the current. If that is what you want, yes, it is correct. Did tiy try running it!?

zzz

keep getting syntax error

So I've tried:

$currentMonth = date(n);

SELECT eventName
FROM t1
WHERE monthNumber => $currentMonth
SELECT 1

still no luck

zzz

got it

it should be >= and not =>

zzz

Still need help. This will pick up any even in this month and I need the next one, today or later....

Also, what is today December and the event is in January? This is clearly not the right approach. I think I need to add
yr+month+date and compare with today's sum. But then again, my events repeat on the same date every year and therefore do not have year associated with them.

NEED HELP

leatherback

store the event date in a date or a timestamp type field and select * where date>lasteventdate limit 1 order by date

zzz

The events repeat annually on the same date, so there's no year field. I do not think I can do without year.

leatherback

ok, fair enough.

Same solution though:
select * where day>day and month > month order by month, day limit 1

Piranha

leatherback wrote:
ok, fair enough.

Same solution though:
select * where day>day and month > month order by month, day limit 1

Sorry, but this won't work. If you have the event the 10th it won't pick up an event the 5th next month. This should work, as long as you don't think about changing year:

select * where (month = month and day > day) or (month > month) order by month, day limit 0, 1

Of course, if you don't get any result you can always run this query to get the first result of the year:

select * order by month, day limit 0,1

leatherback

😐 silly me

zzz

Yep, this worked!