hno Posted June 27, 2009 Share Posted June 27, 2009 HI I wrote this query:"DELETE FROM 'shop'.'comment' WHERE 'comment'.'id'=1 limit 1" and run it with php and mysqli_affected_rows shoes me that the query was successfully run but when I opened phpmyadmin it was still exist and didn't delete from there Why it's not delete ? thanks Link to comment https://forums.phpfreaks.com/topic/163865-problem-with-delete-query/ Share on other sites More sharing options...
trq Posted June 27, 2009 Share Posted June 27, 2009 Firstly, this is the Microsoft SQL - MSSQL help board, are you using MSSql or MySql? I'll assume your using MySql and just posted in the wrong board considering that your talking about phpmyadmin and the LIMIT clause does not exist within MySql. Anyway, your query uses invalid syntax and should be.... DELETE FROM shop.comment WHERE comment.id=1 limit 1 Using strings as identifiers won't get you anywhere. Link to comment https://forums.phpfreaks.com/topic/163865-problem-with-delete-query/#findComment-864582 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.