StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMysqli statement execute error : Result consisted of more than one row
text
Body
copied!<p>I am fetching the three values from TUsers using select query where I am getting the error as </p> <p>Mysqli statement execute error : Result consisted of more than one row.</p> <p>I have used DISTINCTROW for avoiding duplication and I am using Zend framework to call the procedure.</p> <p>Here is the code:</p> <p>Procedure:</p> <pre><code> CREATE DEFINER=`root`@`` PROCEDURE `spfetchloginid`(in securityans varchar(50),out email varchar(50),out loginidout varchar(50),out useridout varchar(50)) BEGIN SELECT DISTINCTROW Email,login_id,user_id into email,loginidout,useridout FROM DB.TUsers where SecurityAns=securityans ; END </code></pre> <p>Calling the Procedure in ZendFramework from Controller:</p> <pre><code> $db=Zend_Db_Table::getDefaultAdapter(); $spParams = array(1,'NewValue'); $stmt = $db->query("CALL spfetchloginid('$securityans',@email,@loginidout,@useridout)"); print_r($stmt->fetchAll()); $stmt->closeCursor(); $stmtresult10=$db->query("select @email"); $email_to=$stmtresult10->fetch(); $stmtresult10->closeCursor(); $Emails=$email_to["@email"]; echo $Emails; $stmtresult11=$db->query("select @loginidout"); $loginid=$stmtresult11->fetch(); $stmtresult11->closeCursor(); $loginids=$loginid["@loginidout"]; echo $loginids; $stmtresult12=$db->query("select @useridout"); $userid=$stmtresult12->fetch(); $stmtresult12->closeCursor(); $userids=$userid["@useridout"]; echo $userids; </code></pre> <p>Please tell me any good suggestions when using Zend and My Sql for calling the procedures. </p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload