
28/02/2002, 00:27
|
| | Fecha de Ingreso: febrero-2002
Mensajes: 15
Antigüedad: 23 años Puntos: 0 | |
Re: Mostrando campos con SELECT Aca va:
Código:
<?
switch ($ordenar) {
case 1:
$result = mysql_query("SELECT * FROM 'mailing' ORDER BY 'fecha' ASC");
break;
case 2:
$result = mysql_query("SELECT * FROM 'mailing' ORDER BY 'fecha' DESC");
break;
case 3:
$result = mysql_query("SELECT * FROM 'mailing' ORDER BY 'id' ASC");
break;
case 4:
$result = mysql_query("SELECT * FROM 'mailing' ORDER BY 'id' DESC");
break;
case 5:
$result = mysql_query("SELECT * FROM 'mailing' ORDER BY 'name' ASC");
break;
case 6:
$result = mysql_query("SELECT * FROM 'mailing' ORDER BY 'name' DESC");
break;
case 7:
$result = mysql_query("SELECT * FROM 'mailing' ORDER BY 'email' ASC");
break;
case 8:
$result = mysql_query("SELECT * FROM 'mailing' ORDER BY 'email' DESC");
break;
default:
$result = mysql_query("SELECT * FROM mailing");
break;
}
?>
#######esta es la 1 parte########
|