收到错误-SQLSTATE [21000]:基数违反:1241操作数应包含1列 [英] getting error - SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s)

问题描述

我收到此错误 SQLSTATE [21000]:基数违反:1241操作数应包含1列 有人可以帮助我理解为什么吗?

I am getting this error SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s) can someone help me understand why?

这是我的代码:

<?php


session_start();
$turk_number ='';
$serial='';
$version='';
if(isset($_POST['turk_number']))
{
    $_SESSION['turk_number'] = $_POST['turk_number'];
    $turk_number= $_POST['turk_number'];
}

$hostname = "localhost";
$username = "root";
$password = "";
$dbname = "resolver";

try 
{
    $dbh = new PDO("mysql:host=$hostname;dbname=$dbname", $username, $password);

    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $query1 = "SELECT ((SELECT * FROM participants ORDER BY serial DESC LIMIT 0, 1) % 10) + 1 as version";
    //$results = $dbh->query($query1);
        $results = $dbh->prepare($query1);
        $results->execute();
        $serial = $results->fetchColumn(0);
    if($test= $results->fetchColumn(1))     
    {
        $version = $test;   //last version on record + 1
    }
    else //if no user ever played any games
    {
        $version = 1;
    }
    $query2 = "INSERT INTO participants (version) VALUES (:version, :turk_number)";
        $stmt = $dbh ->prepare($query2);
        $stmt ->execute(array(':version' => $version,
                            ':turk_number' => $turk_number));

}
catch(PDOException $e)
{
    echo $e->getMessage();
}   

$_SESSION['serial']= $serial;
$_SESSION['version']=$version;


?>
serial <?php print $serial; ?><br />
version <?php print $version; ?><br />
turk <?php print $turk_number; ?>

推荐答案

您正在选择内部查询中的所有列，然后尝试执行％10 ，由于您不能 ％10 到多个列.将其切换为选择一列.

you are selecting all columns in inner query and then trying to do %10, it gives you error because you cant %10 to multiple columns. Switch it to select one column instead.

(SELECT * FROM participants ORDER BY serial DESC LIMIT 0, 1) % 10

选择多个列，然后尝试按 10

selects multiple columns and then tries to mod it by 10

这篇关于收到错误-SQLSTATE [21000]:基数违反:1241操作数应包含1列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！