scratchwax2003 Posted January 17, 2003 Share Posted January 17, 2003 Please help... have created this script to delete stuff from a database table and it works correctly, ie, only deletes if the right id number and password is submitted....BUT if the password or id is incorrect it still throws back the first IF message. I have tried replacing the if ($Query) with if ($Result) and it still does the same thing. here is the full page script: <HTML> <HEAD> <TITLE> CREATING A DATABASE</TITLE> </HEAD> <BODY> <?PHP //trim the incoming data $Array[Remove] = trim ($Array[Remove]); $Array[iDRemove] = trim ($Array[iDRemove]); //set the variables for the database connection: $Host = \"localhost\"; $User = \"\"; $Password = \"\"; $DBName = \"\"; $TableName = \"\"; //have removed above info for obvious reasons!. $Link = mysql_connect ($Host, $User, $Password); $Query = \"DELETE FROM $TableName WHERE Password = \'$Array[Remove]\'AND id= \'$Array[iDRemove]\'\"; $Result = mysql_db_query ($DBName, $Query, $Link); if ($Query){ print(\"Please check to see if your item has been removed.<BR> If it still appears then either a wrong ID was used or your Password was incorrect.\"); } else { print(\"no\"); } mysql_close ($Link); ?> <br><br> <b><font size=\"2\" face=\"Arial, Helvetica, sans-serif\"><a href=\"DataBaseNonElectronic.php\">CHECK IT NOW </a></font></b> </body> </html> im on my knees with this one.... :? Quote Link to comment https://forums.phpfreaks.com/topic/59-delete-works-but-wont-throw-back-right-result/ Share on other sites More sharing options...
pallevillesen Posted January 17, 2003 Share Posted January 17, 2003 You\'re testing if $query is defined... it is! I think you should check $result instead.... EDIT: Woups.... didn\'t read the first lines of your post, sorry.... DELETE deletes rows from table_name that satisfy the condition given by where_definition, and returns the number of records deleted. so use [php:1:a5aeea7a6e] $Query = \"DELETE FROM $TableName WHERE Password = \'$Array[Remove]\'AND id= \'$Array[iDRemove]\'\"; $Result = mysql_db_query ($DBName, $Query, $Link); if ($Result > 0){ print(\"Success....\"); } else { print(\"no\"); } [/php:1:a5aeea7a6e] P. Quote Link to comment https://forums.phpfreaks.com/topic/59-delete-works-but-wont-throw-back-right-result/#findComment-160 Share on other sites More sharing options...
scratchwax2003 Posted January 17, 2003 Author Share Posted January 17, 2003 thanks for the fast response...but i tried that and i keep getting the same result. I am using phpTriad on my system for testing - do you think that it might be something to with that?? i am very baffled by this.... here is the piece i replaced: $Link = mysql_connect ($Host, $User, $Password); $Query =\"DELETE FROM $TableName WHERE password = \'$Array[Remove]\' AND id = \'$Array[iDRemove]\'\"; $Result = mysql_db_query($DBName, $Query, $Link); if ($Result > 0){ print(\"Success....\"); } else { print(\"no\"); } mysql_close($Link); ?> please help again.... Quote Link to comment https://forums.phpfreaks.com/topic/59-delete-works-but-wont-throw-back-right-result/#findComment-161 Share on other sites More sharing options...
effigy Posted January 17, 2003 Share Posted January 17, 2003 you could try mysql_affected_rows() http://www.php.net/manual/en/function.mysq...fected-rows.php Quote Link to comment https://forums.phpfreaks.com/topic/59-delete-works-but-wont-throw-back-right-result/#findComment-162 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.