<tr><td class="label">Store:</td><td>[[storeName? &id=`[+store+]`]]</td></tr>
<?php $table = $modx->getFullTableName("stores"); $query = "SELECT id,nom FROM $table WHERE id = '$id' LIMIT 1"; $result = $modx->db->query( $query ); $row = $modx->db->getRow( $result ); return $row['name'];
<tr><td class="label">Store:</td><td>[[storeName? &id=`2`]]</td></tr>
<tr><td class="label">Store:</td><td>[+store+]</td></tr>
This question has been answered by neoziox. See the first response.
<tr><td class="label">Store:</td><td>[[storeName]]</td></tr>
<?php $id = $_POST['store']; $table = $modx->getFullTableName("stores"); $query = "SELECT id,nom FROM $table WHERE id = '$id' LIMIT 1"; $result = $modx->db->query( $query ); $row = $modx->db->getRow( $result ); return $row['name'];