0

i am trying to delete row and it is deleting but i am getting below error. Can you please have look at code and guide me resolve this issue: ERROR: Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/fqaotczz/public_html/dev/Seller/delete_exec.php on line 25

 CODE
 <?php

//Get data from Session
session_start();
$userid = $_SESSION['userid'];

//Get data from URL
$table = $_GET['table'];
$favprod = $_GET['favprod'];
$page = $_GET['page'];

//Include database connection details
require_once('../connection.php');
include '../Database.class.php';
$dbe_obj = new Database_Executer();

//Create query
$query = "DELETE FROM SELLER_PRODUCT WHERE SELLER_PRODUCT.USER_ID = '$userid' AND SELLER_PRODUCT.PRODUCT_ID = '$favprod'";

$result = $dbe_obj->delete_query_executer($query) or die($query."<br/>".mysql_error());

//Check whether the query was successful or not 
if($result){
    ***if(mysql_num_rows($result) > 0) {***
        //Delete Successful

        $member = mysql_fetch_assoc($result);
        //$first_name = $member["FIRST_NAME"];
        //$last_name = $member["LAST_NAME"];
        $message = "Record deleted successfully.";
        header("Location: $page?message=".$message);

    }
    else {
        //Login failed

        $message = "Record could not be deleted.";
        header("Location: $page?message=".$message);
    }
}
else {
    die("Query failed !");
}  

?>
sher ullah baig
  • 23
  • 4

1 Answers1

1

You must use this http://cz1.php.net/manual/en/function.mysql-affected-rows.php

//Check whether the query was successful or not 
if($result){
    ***if(mysql_affected_rows($result) > 0) {***
        //Delete Successful
Pavel
  • 250
  • 3
  • 10