To get the record count returned by a query in PHP, use the mysql_num_rows function, as follows:
$user = $_POST["Username"];
$pass = $_POST["Password"];
$query = mysql_query(”call MyProcedure(’$user’,’$pass’)”) or die( mysql_error() );
echo mysql_num_rows($query);
