Sample #4: 3 Menus from 2 DB fields:
This example will show you why pulling data from a recordset is cool. The example uses MySQL functions, Check your database documentation to find similiar functions.:

1.- We've got this table, where date is stored in DATE format:

2.- Now, using SQL, we'll find month and year:

3.- The query will return:

4.-Finally, using the extension:

5.- And here is the result:

Back to extension's page| Next Example>>