<?php  
    define('CLIENT_MULTI_RESULTS', 131072);  
    $link = mysql_connect("127.0.0.1", "root", "123",1,CLIENT_MULTI_RESULTS) or die("Could not connect: ".mysql_error());  
    mysql_select_db("test") or die("Could not select database");  
    $sql = "create procedure select_data()  
            begin  
            select * from user;  
            end;";  
    mysql_query($sql);  
        $result = mysql_query("call test.select_data()") or die("Query failed:" .mysql_error());  
        while($row = mysql_fetch_array($result, MYSQL_ASSOC))  
        {  
                $line = '<tr><td><a target = _blank href=\''.$row["name"].'\'>'.$row["name"].'('.$row["pwd"].')'.'</a></td></t  
r>';  
                echo $line;  
                printf("\n");  
        }  
?>