Jump to content

DELETE works but wont throw back right result !


scratchwax2003

Recommended Posts

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.... :?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.... :(

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.