PHP PDO Statement Variable Throwing Syntax Error

Asked Jun 23 '20 at 13:58

Active Jun 23 '20 at 13:58

Viewed 17 times

I'm getting a very confusing/difficult to figure out syntax error on the following block of code:

$query = "SELECT COUNT(*) AS BillCount FROM firms WHERE firm_fk  = ?";
        
$stmt = $this->conn->prepare($query);
$stmt->bindParam(1, $this->id);

$stmt->execute();
$billcount = $stmt->fetchColumn();

The error is in regards to the final line:

$billcount = $stmt->fetchColumn();

And the actual error message is: syntax error, unexpected '$stmt' (T_VARIABLE)

Any ideas? This is driving me crazy!

asked Jun 23 '20 at 13:58

FastTrack

8,810
14
57
78

2

Try deleting that line and the one before it, and retype it. The PHP syntax looks correct, but there may be an invisible character messing things up. – aynber Jun 23 '20 at 14:01
Use `var_dump()` also; you'll see for yourself. – Funk Forty Niner Jun 23 '20 at 14:03
@aynber that was the issue! thank you! So weird... never have to deal with things like this in C# – FastTrack Jun 23 '20 at 14:26

PHP PDO Statement Variable Throwing Syntax Error

0 Answers0