SQL query

Hi,

I’m using a drop down list to let the user choose an event, the values are filtered by event category.

I’m looking for a query to get next event in that category.

I want to make an ajax call after the user choose from the dropdown list the event he want, to get the next event in that category and populate (javascript) another (hidden) field.

The events are always entered in the db in a chronologic logic so i’m just looking for a query to get the next event with the same category with the ID. No need to make difficult queries with the date.

Thanks !

• This topic was modified 6 years, 3 months ago by zar69.
• This topic was modified 6 years, 3 months ago by zar69.