Forum LAMS for Tech-Heads - General Forum: Re: re

By: Ernie Ghiglione

[ Reply | Forward ]

Hi Paris,

Sorry for the delay.

> For my project I want to produce a dropdown list with the list of all lessons. (already done this)
> Then I want (if "first lesson" is selected in the first dropdown list to produce a second dropdown list that lists

Ok, so say I saved a new sequence with the name "Seq1". I should be able to find it in the list of learning design as follow:

mysql> select learning_design_id, learning_design_ui_id, title from lams_learning_design;

+--------------------+-----------------------+-------+

| learning_design_id | learning_design_ui_id | title |

+--------------------+-----------------------+-------+

|                  1 |                  NULL | Seq1  |

+--------------------+-----------------------+-------+

1 row in set (0.00 sec)

If I want to see the activities that this sequence have, I've just need to query the lams_learning_activity table using the learning_design_id:

mysql> select activity_id, title, learning_design_id from lams_learning_activity where learning_design_id = 1;

+-------------+-------------+--------------------+

| activity_id | title       | learning_design_id |

+-------------+-------------+--------------------+

|          35 | Noticeboard |                  1 |

|          36 | Forum       |                  1 |

+-------------+-------------+--------------------+

2 rows in set (0.00 sec)

Is this what you are after?

Thanks

Ernie

Posted by Ernie Ghiglione