SHOW:
|
|
- or go back to the newest paste.
| 1 | $db->useDb('db_0ef4ab21_6314_41a6_b2fe_0cdc523d3624')
| |
| 2 | ->useSchema('Access')
| |
| 3 | ->useTable('TRC Mailing Addresses');
| |
| 4 | ||
| 5 | $sql = 'SELECT '.$db->quoteIdentifier('Address1').', '
| |
| 6 | .$db->quoteIdentifier('City').', '
| |
| 7 | .$db->quoteIdentifier('State').', '
| |
| 8 | .$db->quoteIdentifier('Zip')
| |
| 9 | .' FROM '.$db->getFullDbName().' WHERE ' | |
| 10 | .$db->quoteIdentifier('ID').' = '
| |
| 11 | - | .$db->formatParameterName('id')
|
| 11 | + | .$db->formatParameterName('id') . ' AND '
|
| 12 | .$db->quoteIdentifier('Active').' = 1 '; |
