SirChick Posted September 9, 2007 Share Posted September 9, 2007 I have tried to make a delete query but it won't work it gives me a syntax error but I'm unsure where i have gone wrong.... this is what i have got at the moment: $Deletesoldhouses = "DELETE * FROM soldhouses WHERE SoldHouseID = '$HouseID'"; mysql_query($Deletesoldhouses) or die(mysql_error()); Can any one see what i did wrong? Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM soldhouses WHERE SoldHouseID = '1'' at line 1 Quote Link to comment https://forums.phpfreaks.com/topic/68583-solved-delete-query/ Share on other sites More sharing options...
BlueSkyIS Posted September 9, 2007 Share Posted September 9, 2007 remove the asterisk. Quote Link to comment https://forums.phpfreaks.com/topic/68583-solved-delete-query/#findComment-344756 Share on other sites More sharing options...
SirChick Posted September 9, 2007 Author Share Posted September 9, 2007 thanks ! sorted! Quote Link to comment https://forums.phpfreaks.com/topic/68583-solved-delete-query/#findComment-344758 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.