jesushax Posted February 22, 2008 Share Posted February 22, 2008 hi here is my delete action Case "deletefile" : $ID = $_GET["ID"]; $FileID = $_GET["FileID"]; mysql_query("DELETE * FROM tblCompanyFiles WHERE FileID=".$FileID." ") or die(mysql_error()); header("Location: /companies/admin_edit_company.php?ID=".$ID.""); break; my link <a href=\"/companies/admin_edit_company.php?action=deletefile&FileID=".$rsfiles["FileID"]."&ID=".$ID."\">Delete File</a> and error message 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 tblCompanyFiles WHERE FileID=1' at line 1 i cant see whats wrong :S frustrated i am! lol cheers Link to comment https://forums.phpfreaks.com/topic/92455-problem-with-sql-delete/ Share on other sites More sharing options...
peranha Posted February 22, 2008 Share Posted February 22, 2008 DELETE FROM tblCompanyFiles WHERE FileID=".$FileID." There is no *, it is just DELETE FROM Link to comment https://forums.phpfreaks.com/topic/92455-problem-with-sql-delete/#findComment-473678 Share on other sites More sharing options...
jesushax Posted February 22, 2008 Author Share Posted February 22, 2008 ahhh, i did not know that lol, dammit! thanks though! alot!!!! Link to comment https://forums.phpfreaks.com/topic/92455-problem-with-sql-delete/#findComment-473681 Share on other sites More sharing options...
revraz Posted February 22, 2008 Share Posted February 22, 2008 Does your header statement work with that leading "/" slash? Link to comment https://forums.phpfreaks.com/topic/92455-problem-with-sql-delete/#findComment-473692 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.