|
|
Posted by Big Moxy on 08/13/07 19:21
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()) {
$_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));
Navigation:
[Reply to this message]
|