Forums

Chronoforms and PHP Admin

Ann 28 Jul, 2009
Hi,

I have created a chrono form and linked it to the table in PHP.

But now i wish to edit the chronoform and allow it to reflect changes on the table (PHP).

I also need to change the table so that it appears in chronological order - how do i do that without messing up my tables?

Will i be able to edit the chronoforms and tables?

Please advise
GreyHead 31 Jul, 2009
Hi Ann,

To update the table to match changes in your form you ahve two choices.

If you have no important data saved then Drop the current table using PHPMyAdmin or something similar and create a new version using the ChronoForms Create Table icon.

If you have data you need to keep then add new columns to the table in PHPMyAdmin. Then unmake and re-make the table connection in the DB Conenction tab in ChronoForms. Provided that the column names exactly match the field names the data will be saved OK.

You can't change the table so that it appears in chronological order. You will need to add an ORDER BY clause to the SQL statement you use to view the data.

The data viewer in ChronoForms is very basic and you can't easily do this. ChronoConnectivity will let you add an ORDER BY entry.

Bob
This topic is locked and no more replies can be posted.