To allow the users browse the articles in an easy manner, you have to add a navigation menu. This will be stored in its own page, in the front folder. The menu will display links only to pages that contain a list of articles, as each list will point to the articles it contains, allowing the users to read them.
To create the menu, follow the next steps:
Open the front/menu.php page.
Create a recordsetA recordset is the result of executing an SQL query. It is composed of multiple rows, each row having multiple columns. The columns presented in the query result depend on the column list declared in the query (they can belong to different tables). The number of rows and their order depend on the query conditions (WHERE, GROUP BY, HAVING, ORDER). The recordset acts as a source of dynamic dataThe InterAKT Dynamic Data tool is a replacement for the standard dynamic data dialog. It is used in the MX Kollection 3, to provide a unified way of building mark-ups, or place holders. These are recordset fields, server or session variables, and other types of dynamic data that are replaced at runtime by their corresponding values in web applications. with the titles of the articles on the first level.
Create a dynamic table (Insert bar -> Application tab) with all the records in the rsMenu recordset.
Delete the first row, to remove the column headings.
Delete the columns containing the primary keyA primary key is one or more table columns whose values uniquely identify each record in a table. In general, a primary key is defined on a single column, but it is not uncommon to have it defined on two columns. and the self foreign keyA foreign key is a field from a database table that refers to (or targets) a specific key, usually the primary key, in another table. This is a convenient way of logically linking information from related tables in the same database. For instance, a table that stores information about products can contain a foreign key that references the primary key field in a table that stores manufacturers. This way, each product has an associated manufacturer – its associated foreign key points to the unique identifier of the manufacturer. Please note that the foreign key is not unique, but the referenced field (the primary key in the referenced table) usually is. .
Link the dynamic text to the view_list.php page and pass it the id_pag URL parameter:
Here it is how the menu looks in Dreamweaver design view:
