DROP PROCEDURE IF EXISTS `CALL`.`sp_login`$$
 
CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_login`(userid VARCHAR(50),pass VARCHAR(50),out chk INT(11),out user_alias VARCHAR(50),out user_tariff VARCHAR(50),out c_credit DECIMAL(15,5),out r_reseller VARCHAR(10),out r_level VARCHAR(10),out c_tariff CHAR(2))
BEGIN
SELECT id INTO chk FROM cc_reseller  WHERE useralias =userid AND uipass=pass AND level!=0 AND activated!='0';
if(chk!="") THEN
SELECT id,useralias,tariff,credit,reseller,level,create_tariff INTO chk,user_alias,user_tariff,c_credit,r_reseller,r_level,c_tariff FROM cc_reseller WHERE useralias =userid AND uipass=pass AND activated!='0' AND level!=0;
END if;
    END$$
 
DELIMITER ;

<?php
    ob_start();
  include_once('config.php');
  $username = $_POST['username'];
  $password = $_POST['password'];
 
  if (isset($_POST['username']) && $_POST['username']!='')
        {
            $username=$_POST['username'];
            $password=$_POST['password'];        
            $query="call sp_login('$username','$password',@chk,@user_alias,@user_tariff,@c_credit,@r_reseller,@r_level,@c_tariff)";
            $result=mysql_query($query) or die('Query error'.''.mysql_error());
            $count=mysql_fetch_row($result);
 
 
            $chk = $count[0];
            if($chk !="")
            {
                $n_name = $count[1];
                $n_tariff = $count[2];
                $n_username = $count[3];
                $n_creator = $count[4];
                 $n_credit = $count[5];
                $_SESSION['username'] = $n_username;
                $_SESSION['user_id'] = $chk;
                $_SESSION['tariff'] = $n_tariff;
                $_SESSION['reseller'] = $n_creator;
                $_SESSION['ncredit'] = $n_credit;
 
                header('Location:welcomes.php');
            }
            else
            {
                header("location:index.php?q=-2");
            }    
        }
        else
        {
            if(!isset($_SESSION['username']) || $_SESSION['username']=='')
            {
                header("location:index.php?q=-1");
            }
        } 
?>

Query errorPROCEDURE call.sp_login can't return a result set in the given context
 

 $con = mysql_connect('localhost','root','',false,65536);