Doubt : obtaining the original creation date of a FAQ record
Posted: Thu Jan 06, 2011 7:55 pm
Doubt : obtaining the original creation date of a FAQ record – is it possible?
Dear Thorsten / dear All
Does phpMyFAQ’s DB store permanently - and in a non-modifiable way - the original creation date of a FAQ record?
We need to create a report with the number and the question text of FAQ records created on 2009 and 2010 (separately).
Some 2009's FAQs were reviewed in 2010.
We tried several direct MySQL SQL queries on the DB tables/fields (datum, solution_id, revision_id, …)
without consistent results.
Is it possible to obtain this kind of reports?
Software and versions :
phpMyFAQ - 2.6.13
Database Server - MySQL
Database Client Version - 5.1.54
Database Server Version - 5.5.8
PHP - 5.3.4
Thanking in advance
Kind regards
2011-01-06
pt20100201
Dear Thorsten / dear All
Does phpMyFAQ’s DB store permanently - and in a non-modifiable way - the original creation date of a FAQ record?
We need to create a report with the number and the question text of FAQ records created on 2009 and 2010 (separately).
Some 2009's FAQs were reviewed in 2010.
We tried several direct MySQL SQL queries on the DB tables/fields (datum, solution_id, revision_id, …)
without consistent results.
Is it possible to obtain this kind of reports?
Software and versions :
phpMyFAQ - 2.6.13
Database Server - MySQL
Database Client Version - 5.1.54
Database Server Version - 5.5.8
PHP - 5.3.4
Thanking in advance
Kind regards
2011-01-06
pt20100201