Ver Mensaje Individual
  #2 (permalink)  
Antiguo 28/02/2002, 00:27
dachi
 
Fecha de Ingreso: febrero-2002
Mensajes: 15
Antigüedad: 22 años, 1 mes
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########