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 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. 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! Link to comment https://forums.phpfreaks.com/topic/68583-solved-delete-query/#findComment-344758 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.