In the Link field in the Property inspector, add the following string at the end of the URL:
?recordID=<?php echo $row_
The question mark tells the server that what follows is one or more URL parameters. The word
recordID is the name of the URL parameter (you can use any name you like). Make a note of the name of the URL parameter because youll use it in the detail page later.
The expression after the equal sign is the value of the parameter. In this case, the value is generated by a PHP expression that returns a record ID from the recordset. A different ID is generated for each row in the dynamic table. In the PHP expression, replace
recordsetName with the name of your recordset, and replace
fieldName with the name of the field in your recordset that uniquely identifies each record. In most cases, the field will consist of a record ID number. In the following example, the field consists of unique location codes.
locationDetail.php?recordID=<?php echo $row_rsLocations['CODE']; ?>
When the page runs, the values of the recordsets CODE field are inserted in the corresponding rows in the dynamic table. For example, if the Canberra, Australia, rental location has the code CBR, then the following URL will be used in the Canberra row in the dynamic table: