MySQL SELECT works but DELETE doesnt

Anyone know why selecting from the database would work just fine with php PDO execute() but trying to delete a row doesn't even pass the query to MySQL?

My select statement:


My delete statement:


If there's nothing wrong with my SQL syntax let me know and I'll post my php code that I'm using to submit the queries.

Good lord I hate that, debug for 3 hours and can't figure it out and then post about it and instantly figure out the problem. Had my id in the query as an argument in my PHP function. But wasn't passing in the argument when calling the method (e.g. delete_player() instead of delete_player(5)).

Glad you figured out your problem, sometimes the simplest problems are the most time consuming to find!

You might start posting it here after 15 minutes of debugging, and then you will solve it right away due to that fact. Maybe there is some magical influence Ozzu has on your debugging skills that enables you to solve problems quickly

Glad you figured out your problem! Sometimes the simplest problems are the most time consuming to fix!

heh, I'll try that. You're about to see me blow up your forum with posts anytime I get stuck on something more than 5 minutes j/k