URGENT: Creating reports automatically using MySQL client version: 4.1.10

[christopherdown]

Hi There,

I am new to big databases so need a little bit of help. I have created a web based form which submits the data to a MYSQL database.

What i need to do is take these fields

• Name
  Reason_For_Call
  Comment
  Taken_By
  Date

With these fields i need to some how have this data go into a report which needs to be generated once every 24 hours and emailed out.

I some how also need to make it so it only takes new data in the report

Does anyone know how to do this????

Thanks for your help

Have A Safe & Happy New Year

Christopher Downs

[Michael Raven]

you can schedule some report tool for selecting data (according your criteria) , making report and email it (email operation may depend on different tool)

[christopherdown]

you can schedule some report tool for selecting data (according your criteria) , making report and email it (email operation may depend on different tool)

Hi Micheal Raven,

Do you know of any free report tool in can use?

Thanks

Christopher DOwns

[Michael Raven]

Do you know of any free report tool in can use?

Unfortunately "pure free" tools to me are unknown.
May be some kind of EMS DB Extract for MySQL, SQLyog or other with ability to extract data to (for example) HTML format on sheduled base