Delete Query

[Corbokhan]

Hey everyone,

 

I'm having some trouble with a delete query that I can't quite figure out.

 

When I delete one item using the query, "DELETE FROM APPS where appID='1' AND userID='1';" the query works fine and the row is deleted.

 

When I delete one item at a time but use multiple queries the rows are not deleted. For example, I would call "DELETE FROM APPS where appID='1' AND userID='1';" and then "DELETE FROM APPS where appID='2' AND userID='1';" - Neither row is deleted.

 

Finally when I delete multiple items using one query , "DELETE FROM APPS where appID='1' OR appID='2' AND userID='1';" - Neither row is deleted.

 

Each of these queries work when I paste them directly into phpmyadmin, but not when using myslqi_query on a webpage.

 

Any ideas why these queries aren't running successfully?

 

[edit] Also, the queries that are not successfully running do not come back with an error message, they just do not perform the task.

[fugix]

Do you have your code set to display mysql errors via mysql_error() ?

[Corbokhan]

I actually just figured it out. I needed to add quotations. Been a long night!

 

Thanks for the quick response though.