|
|
Posted by Jerry Stuckle on 08/13/07 19:27
Big Moxy wrote:
> On Aug 13, 12:44 pm, burgermeiste...@gmail.com wrote:
>> On Aug 13, 12:53 pm, Big Moxy <bigm...@gmail.com> wrote:
>>
>>> Can someone please advise me on how to implement this?
>>> The data entered by a user on form 1 on page1.php is posted to
>>> delete.php to remove that row from a table. After the SQL operation
>>> the user is returned to page1.php.
>>> How can I determine the success or failure of the SQL operation so I
>>> can display an appropriate response message to the user?
>>> Thank you!
>> Another option is this:
>> mysql_query() will return false if an error occurs, so if you put your
>> execute statement in an if statement as following you can get a
>> boolean success/failure response:
>> if(mysql_query()){
>> return "Yay! Success";}else{
>>
>> return "Failure";
>>
>> }
>>
>> Additionally, mysql_error() can tell you what went wrong.
>
> Apparently today is not my lucky day. When no row is deleted the URL
> is pointing to my delete.php and not page1.php yet the browser display
> seems to refresh.
>
> BTW I got the same result with the mysql_affected_rows().
>
> Here is a snippet of the delete.php code -
>
> $Result1 = mysql_query($deleteSQL, $emailmanager) or
> die(mysql_error());
> if (mysql_query()) {
Why are you calling mysql_query() again? You want to test $Result1 -
which you already did with die() (a bad choice here!).
> $_SESSION["mysql_query_result"] = "Your email address has been
> successfully removed";
> }
> else {
> $_SESSION["mysql_query_result"] = "Your email address was not
> found. Please try again";
> }
> $deleteGoTo = "/casper/emailmanager.php";
> if (isset($_SERVER['QUERY_STRING'])) {
> $deleteGoTo .= (strpos($deleteGoTo, '?')) ? "&" : "?";
> $deleteGoTo .= $_SERVER['QUERY_STRING'];
> }
> header(sprintf("Location: %s", $deleteGoTo));
>
Rather:
if (mysql_query($deleteSQL,$emailmanager) && mysql_affected_rows()>0)) {
$_SESSION["mysql_query_result"] = "Your email address has been
successfully removed";
}
else {
$_SESSION["mysql_query_result"] = "Your email address was not
found. Please try again";
}
(sorry about the wrapping).
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|