Unknown SQL syntax error

Question

0.00/5 (No votes)

See more:

I used a sql statement :

$sql = "DELETE * FROM groups_members WHERE groups_id =" . $groupId . " AND user_id =" . $userId . "";

But it gives me the error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '* FROM groups_members WHERE groups_id =1 AND user_id =4' at line 1. I don't understand why, and it isn't even on line 1...

What I have tried:

I tried putting the variables in {} but it still didn't help. Plz help.

Posted 2-Aug-20 6:09am

Member 14904885

Updated 2-Aug-20 6:18am

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

User 11060979 · Accepted Answer · 2020-08-02T06:18:00

This

SQL

$sql = "DELETE FROM groups_members WHERE groups_id =" . $groupId . " AND user_id =" . $userId . "";

instead of

SQL

$sql = "DELETE * FROM groups_members WHERE groups_id =" . $groupId . " AND user_id =" . $userId . "";

should solve the syntax error.

Important: Use parameterized queries to avoid SQL injection.

Unknown SQL syntax error

1 solution

Solution 1

Add your solution here

Preview 0

Unknown SQL syntax error

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us