Unable to execute() query

Question

I'm trying to get data from a MySQL database and I get:

Fatal error: Call to a member function execute() on a non-object in Line 79...

on this line:

$stmt->execute();

I'm just trying to get this: enter image description here

and more specifically the left data cell (very right of pic) that is an int(5).

Here's what I have:

$query = "SELECT left FROM members WHERE id=$uid";

$stmt = $mysqli->prepare($query); 

    $stmt->execute();
    $stmt->bind_result($left);
    $stmt->fetch();
    echo "Left: $left";
    $stmt->close();

Funny thing is, when I change SELECT left to something like SELECT username, I get the username cell back as expected, but for left I get the error.

Why not to use search first? [Mysqli update throwing Call to a member function bind_param() error](http://stackoverflow.com/a/15447204/285587) — Your Common Sense, May 30 '13 at 05:42
and then http://dev.mysql.com/doc/refman/5.6/en/reserved-words.html — Your Common Sense, May 30 '13 at 05:44

score 2 · Accepted Answer · answered May 30 '13 at 05:46

2

Add quotes:

SELECT `left` FROM `members` WHERE id=$uid

answered May 30 '13 at 05:46

Atber

465
2
5

wazy · Answer 2 · 2013-05-30T18:57:28.820

-1

Try

$query = "SELECT `left` FROM members WHERE id=$uid";

to avoid reserved keyword problem.

Edit:

Including comment from Your Common Sense to link

http://dev.mysql.com/doc/refman/5.6/en/reserved-words.html

edited May 30 '13 at 18:57

answered May 30 '13 at 05:46

wazy

1,065
1
10
23

Unable to execute() query

2 Answers2