Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]:

Question

I have a query where I am counting rows but it's showing this error..

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from=? AND to=?' at line 1' in C:\wamp\www\network\profile.php on line 38

( ! ) PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from=? AND to=?' at line 1 in C:\wamp\www\network\profile.php on line 38

Here's my code :

$sql_check_friend = "SELECT COUNT(*) FROM connection_request WHERE from=:me AND"; 
$sql_check_friend .= "to=:friend";
    
$sth = $db->prepare($sql_check_friend);
$sth->bindParam(":me", $me);
$sth->bindParam(":friend", $pageuserid);
$sth->execute();

$count = $sth->fetchColumn();

if($count > 0){
echo "REQUEST SENT";
}else{
echo "NOT SENT";
}

I can't figure out what's wrong..

You're missing "; on your 1st line, and a " on your 2nd line. — gen_Eric
– gen_Eric, Commented Feb 18, 2014 at 21:59
i broke the code up here.. on my editor it's on one line.. I will edit this one though.. — user3184462
– user3184462, Commented Feb 18, 2014 at 22:00

Marc B · Accepted Answer · 2014-02-18 22:00:04Z

8

from is a reserved word. It must be escaped in your query:

 SELECT ... WHERE `from` := ...
                  ^--  ^---

And ditto for to as well - it's a reserved word too.

answered Feb 18, 2014 at 22:00

Marc B

362k44 gold badges433 silver badges508 bronze badges

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

1 Comment

Marc B Over a year ago

@jorge: probably just a typo here, otherwise there'd be far more sql errors and php syntax errors to boot.

William Prigol Lopes · Accepted Answer · 2021-05-17 04:46:58Z

0

This is because your string/text connection may contain quotes like this: ",' or `. try removing these quotes and then execute query, so validate your connection string.

edited May 17, 2021 at 4:46

William Prigol Lopes

1,90519 silver badges33 bronze badges

answered May 15, 2021 at 6:01

Aadil Bashir Dar

1

Collectives™ on Stack Overflow

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]:

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related