Prepared statement is returning empty results, possible syntax error

Question

When I execute the prepared statement the results are returned empty. If I copy and paste the statement into phpMyAdmin it executes properly. $_SESSION['userGroup'] has been checked and confirmed to contain the proper value but $systems remains undefined.

Am I missing something?

        $stmt = $mysqli -> prepare("SELECT `Systems` FROM `groups` WHERE `GroupID` = ?");
            echo $mysqli -> error;

        $stmt -> bind_param('i', $_SESSION['userGroup']);
        $stmt -> execute();
        $stmt -> store_result();
        $stmt -> bind_result($systems);

Your Common Sense · Accepted Answer · 2014-04-01 13:03:08Z

1

Am I missing something?

you are missing documentation and/or tutorial to learn from.
Where you can learn the proper syntax that should include

$stmt -> fetch();

answered Apr 1, 2014 at 13:03

community wiki

Your Common Sense

Sign up to request clarification or add additional context in comments.

Comments

TheCutter · Accepted Answer · 2014-04-01 13:08:02Z

0

Just try

$stmt -> bind_param('i', $_SESSION['userGroup']);
$stmt -> execute();
$stmt -> bind_result($systems);
$stmt -> fetch();

answered Apr 1, 2014 at 13:08

TheCutter

1531 silver badge8 bronze badges

1 Comment

Styles2304 Over a year ago

Yes, that's exactly what I was looking for. I had just been looking at it too long. Thank you.

Collectives™ on Stack Overflow

Prepared statement is returning empty results, possible syntax error

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related