Código PHP:
Ver original<?php
$hostname_connected = "localhost";
$database_connected = "nombre_basededatos";
$username_connected = "root";
$password_connected = "";
$connected = mysql_pconnect($hostname_connected, $username_connected, $password_connected); #Conectando con tu base de datos
?>
<?
#definiendo la variable
{
$dia_elegido = $_GET['dias'];
#realizando la consulta sql
$consultasql = "SELECT * FROM '$dia_elegido' ORDER BY fecha DESC";
}
?>
Código HTML:
Ver original<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<!-- Formulario de filtro -->
<form action="#" method="get"> <? if(isset($_GET['dias'])){?>
<table border="0" cellpadding="0" cellspacing="0" width="95%" > <?php do { ?>
<td><?php echo $row_TABLA['jornada']; ?></td> <td><?php echo $row_TABLA['partido']; ?></td> <td><?php echo $row_TABLA['fecha']; ?></td> <td><?php echo $row_TABLA['hora']; ?></td>
<?php } while ($row_TABLA = mysql_fetch_assoc($rsTABLA)); ?>
<? ;}?>