<? PHP
$ Link = mysql_connect ("localhost", "root", "root ");
$ Db = mysql_select_db ("bustest", $ link );
$ Sql1 = "Select name from Info group by name order by id asc ";
Print ("<Table border = '1'> ");
$ RES1 = mysql_query ($ sql1 );
While ($ row1 = mysql_fetch_array ($ RES1 )){
$ Name = $ row1 ["name"];
$ Sql2 = "select ID from info where name = '$ name' order by id asc ";
$ RES2 = mysql_query ($ sql2 );
While ($ row2 = mysql_fetch_array ($ RES2 )){
Print ("<tr> ");
$ Id = $ row2 ["ID"];
Print ("<TD> $ id </TD> ");
$ Sql3 = "select count (*), ID from info where name = '$ name' group by name order by id asc ";
$ RES3 = mysql_query ($ sql3 );
While ($ row3 = mysql_fetch_array ($ RES3 )){
$ Id1 = $ row3 ["ID"];
If ($ id1 = $ id ){
$ Num = $ row3 [0];
Print ("<TD rowspan = '$ num'> ");
Print $ name;
Print ("</TD> ");
} Else {
Print ("</tr> ");
}
}
}
Print ("</tr> ");
}
Print ("</table> ");
Mysql_close ($ link );
?>