If you dont want to show record IDs to users, you can delete the column from the dynamic table.
The recordset must also include the table column containing the unique key of each record-that is, the record ID column. Make sure the recordset contains all the table columns you need to create your dynamic table. If you want to write your own SQL statement, click the Advanced button to open the advanced Recordset dialog box. For more information, click the Help button on the dialog box. In the Bindings panel (Window > Bindings), click the Plus (+) button, select Recordset (Query), and complete the Recordset dialog box. Select File > New > Dynamic, select PHP, and click Create. For more information, see Database Connections for PHP Developers. You can use a dynamic table to list the records on a PHP page.īefore you start, make sure you define a database connection for the site.
This section describes how to create a master page that lists database records.