Jump to content

Archived

This topic is now archived and is closed to further replies.

scratchwax2003

DELETE works but wont throw back right result !

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

Share this post


Link to post
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.

Share this post


Link to post
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.... :(

Share this post


Link to post
Share on other sites

×

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.