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 Quote Link to comment 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 Quote Link to comment 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!!!! Quote Link to comment 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? Quote Link to comment 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.