Syntax failure in PHP call to a Select

0

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>
    
asked by Alberto Cepero de Andrés 15.06.2017 в 18:27
source

0 answers