Getting LMS database inormation
October 26, 2007 12:00 AM
I am trying to create a certificate that is accessible only after completing several courses and can be accessed by the student at any time, but the date on the certificate will always be the completion date that is set upon first entry into the certificate by the lms. The courses are all on the same lms. The cerificate would be set up with all of the required courses as prerequisites.I want to be able to get the completion date of the certificate course and display it in the certificate. The SQL statement to get the data is:SELECT statusdt1 FROM courseswhere statusdt1 is the column name and courses is the table name.Does anyone have a simple solution to this?Ron HoffHealthcare Academy
Discussions have been disabled for this post