<?php // create table album ( artista varchar2(40) , album varchar2(60), supporto varchar2(5) , stile varchar2(5), voto number , anno number ); $conn = odbc_connect ("o_facs", "user" , "password"); /* $c1= odbc_exec( $conn,'select artista , album, supporto , stile , to_char(voto) voto , to_char(anno) anno from album order by 1'); */ $c1= odbc_exec( $conn,' select fn_html_a( artista, link) "elenco dei link esterni" from album where link is not null order by artista '); odbc_result_all ($c1,"border"); odbc_close ($conn); /* -------------------------------------------------- create or replace function fn_html_a (xnome varchar2, xurl varchar2 ) return varchar2 is begin return '<a href="'||xurl||'">'||xnome||'</a>'; end; / order by artista'); order by to_number(voto) desc, artista asc'); order by stile, artista'); -- distibuzione dei voti select count(*) , trunc (voto/10) from album a group by trunc (voto/10) order by 2,1 -- select artista, link from album where link is not null order by 1 */ ?>