PHP generates table instance code

The following code is used to generate a table instance in PHP, which is post after the program home test runs normally on this site. & Lt ;? Php $ linkmysql_connect (localhost, root, 123456); $ dbmysql_select_db (bustest, $ link); $ sql1selectnamefrominfogroupbynameorderbyi the code below PHP generates a table instance, after testing the normal operation of this site's programming House, it was posted.

2. $ Link = mysql_connect ("localhost", "root", "123456 ");
3. $ Db = mysql_select_db ("bustest", $ link );
4. $ Sql1 = "select name from info group by name order by id asc ";
5. Print ("
6. $ Res1 = mysql_query ($ sql1 );
7. While ($ row1 = mysql_fetch_array ($ res1 )){
8. $ Name = $ row1 ["name"];
9. $ Sql2 = "select id from info where name = $ name order by id asc ";
10. $ Res2 = mysql_query ($ sql2 );
11. While ($ row2 = mysql_fetch_array ($ res2 )){
12. Print ("
13. $ Id = $ row2 ["id"];
14. Print ("
15. $ Sql3 = "select count (*), id from info where name = $ name group by name order by id asc ";
16. $ Res3 = mysql_query ($ sql3 );
17. While ($ row3 = mysql_fetch_array ($ res3 )){
18. $ Id1 = $ row3 ["id"];
19. If ($ id1 = $ id ){
20. $ Num = $ row3 [0];
21. Print ("
22. } Else {
23. Print ("
24. }
25. }
26. }
27. Print ("");
28. }
29. Print ("
"); "); "); "); ");

$ Id	"); Print $ name; Print ("

");
30. Mysql_close ($ link );
31. ?>