Can someone tell me why I am getting a bool value back out of this proc?

Question

I have several procedures on this machine and this is the only query that is giving me a boolean value (at least I think it is a boolean value) in my PHP code. When I substitute this procedure with another one, this value goes away. Is there a problem with this code the way I have it?

CREATE DEFINER=`root`@`%` PROCEDURE `phoneIsRegistered`
(IN iPhone bigint(10), OUT oPhone bigint(10))
BEGIN

        SELECT
          phone
        FROM
            user
        WHERE
            phone = iPhone
        INTO
            oPhone;
END;

---

Here is what the array looks like with this value I'm talking about.

mysqli_result Object
(
    [current_field] => 0
    [field_count] => 2
    [lengths] => 
    [num_rows] => 110
    [type] => 0
)
mysqli_result Object
(
    [current_field] => 0
    [field_count] => 1
    [lengths] => 
    [num_rows] => 12
    [type] => 0
)
1                    <-------------------------------------HERE
mysqli_result Object
(
    [current_field] => 0
    [field_count] => 1
    [lengths] => 
    [num_rows] => 1
    [type] => 0
)

Answer 1

First of all there's a syntax error, in that you're using ';' both for the inner query and the create procedure. You need to "DELIMITER='//';" before the procedure and then use "END//". But still use ';' on the inner query.

DELIMITER '//'
CREATE PROCEDURE...
  ..
END//
DELIMITER ';'

Answer 2

I answered this question for you on your other post.

http://stackoverflow.com/questions/2013668/having-more-issues-with-mysqli-numerical-data-in-results

Metropolis