I have this select to show some data in parentheses, but I think it has a syntax failure:
<select class="form-control" name="compania1" id="compania1">
<option value="<?php echo isset($obj_categoria) ? $obj_categoria->__GET('compania') : ''; ?>"><?php echo isset($obj_categoria) ? $obj_categoria->__GET('compania') : ''; ?> </option>
<?php
$pdo = new PDO('mysql:host=localhost;dbname=final', 'root', '');
$pdo->setAttribute(PDO::MYSQL_ATTR_INIT_COMMAND, "SET NAMES 'utf8'");
$pdo->exec("SET NAMES 'utf8';SET lc_messages = 'es_ES'");
#Set Error Mode to ERRMODE_EXCEPTION.
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$stmt = $pdo->prepare('Select * from compania order by acronimo');
$stmt->execute();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
echo '<option name="' .
($row['acronimo']) . '">' .($row['acronimo'] . '(' .$row['nombre'] . ')') . '</option>';
}
?>
</select>