Mostrando campos con SELECT

[dachi]

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########