Query

wjm69

I have an Sql table. I used table generater to create the code for the table. The table displays perfectly. I would like the table to only display records within a date range. Which file and what should the code look like?

Thank you.

allan

Hi,

The documentation here explains how you can apply a where condition to the data that is being read from the database.

Regards,
Allan

wjm69

I used the generator to make the table. Which file in generator does the where statement explained above go?

thanks, wiley

wjm69

figured it out. thanks.

allan

Hi,

Good to hear you've got it working. For anyone else that finds this thread, you would modify the table.*.php file that Generator creates (in the php directory).

Allan