I have a table in a database called 'threads' and I want to delete a row where the id is equal to $forumid which is set by the URL. The URL looks something like this: domain.com/viewThread.php?forumid=1
I am getting this using
$forumid = $_GET['forumid'];
and I am sure that this is working because I use
echo $forumid;
and it works correctly. But when I go to delete a row using
$db->query("DELETE FROM threads WHERE id='$forumid'");
its not working for some reason.
Can somebody please help me with this? Is it possible that there is something wrong with my phpMyAdmin or mySQL database?
解决方案
Check the query
("DELETE FROM threads WHERE id= '.$forumid.'");