}
// Database connection data.
require_once 'db.php';
// Realizamos la consulta de los equipos
// Ordenandolos segun campo y asc o desc
$where = "";
if ($name !== "") {
$where .= "WHERE name1='" . mysql_real_escape_string($name) . "'";
$where .= "OR name2='" . mysql_real_escape_string($name) . "'";
}
if ($surname !== "") {
$where .= "WHERE name1='" . mysql_real_escape_string($name) . "'";
$where .= "OR name2='" . mysql_real_escape_string($name) . "'";
}
$result = db_query("SELECT * FROM team {$where} ORDER BY {$campo} {$orden}");
// if ($surname == "") {
//
// }
//mostramos los resultados mediante la consulta de arriba
while ($MostrarFila = mysql_fetch_array($result)) {
$id = $MostrarFila['id'];
echo "<tr> \n";
// echo "<td" . estiloCampo($campo, 'name1') . ">" . $MostrarFila['name1'] . "</td> \n";
echo "<td" . estiloCampo($campo, 'name1') . ">" . $MostrarFila['name1'] . " " . $MostrarFila['surname1'] . " / " . $MostrarFila['name2'] . " " . $MostrarFila['surname2'] . "</td> \n";
echo "<td" . estiloCampo($campo, 'surname1') . ">" . $MostrarFila['surname1'] . "</td> \n";
echo "</tr> \n";
}
}
?>
</table>
<br /><a href="index.php">Volver</a>
$criteria .= " AND name1='{$name}' ";
$criteria .= " OR name2='{$name}' ";
}
if ($surname !== "") {
$criteria .= " AND surname1='{$surname}' ";
$criteria .= " OR surname2='{$surname}' ";
}
$dbh = new Database();
$sql = "SELECT * FROM team {$criteria} ORDER BY {$campo} {$orden}";
// echo '<pre>';
// print_r($sql);
$sth = $dbh->prepare($sql);
$sth->execute();
$sth->setFetchMode(PDO::FETCH_ASSOC);
// $row = $sth->fetch();
// echo '<pre>';
// print_r($row);
//mostramos los resultados mediante la consulta de arriba
while ($row = $sth->fetch()) {
$id = $row['id'];
echo "<tr> \n";
// echo "<td" . estiloCampo($campo, 'name1') . ">" . $row['name1'] . "</td> \n";
echo "<td" . estiloCampo($campo, 'name1') . ">" . $row['name1'] . " " . $row['surname1'] . " / " . $row['name2'] . " " . $row['surname2'] . "</td> \n";
echo "<td" . estiloCampo($campo, 'surname1') . ">" . $row['surname1'] . "</td> \n";
echo "</tr> \n";
}
} catch (PDOException $e) {
echo "I'm sorry, Dave. I'm afraid I can't do that.";
file_put_contents('PDOErrors.txt', $e->getMessage() . "\n", FILE_APPEND);
echo $e->getMessage();
}
