[SOLVED] Help with a Search Function

[CodeMama]

Hi All,

today's problem I need some help with is getting a search to work, keeps giving me the mysql_num_rows error, I know there is data in the db, and when I search for a particular record I still get this.

Here's the code:

<?php
session_start();
include("inc/dbconn_open.php");

if (empty($_SESSION['AdminLogin']) OR $_SESSION['AdminLogin'] <> 'OK' ){
    header ("Location: LogOut.php");
}

if (isset($_GET['AdminID']) && !empty($_GET['AdminID'])){
    $AdminID = $_GET['AdminID'];
} elseif (isset($_POST['AdminID']) && !empty($_POST['AdminID'])){
    $AdminID = $_POST['AdminID'];    
} else {
    header ("Location: LogOut.php");
}

    $query = "SELECT SearchWorkOrder FROM admin WHERE AdminID='$AdminID'";
    $result = mysql_query ($query);
    $row = mysql_fetch_object ($result);
    if ($row->SearchWorkOrder == "NO") {
        header ("Location: Welcome.php?AdminID='.$_SESSION[AdminLogin]'&msg=Sorry, you do not have access to that page.");
    }

if (isset($_POST['WorkOrderID'])) {$WorkOrderID = $_POST['WorkOrderID'];} else {$WorkOrderID = '';}
if (isset($_POST['WorkOrderName'])) {$WorkOrderName = $_POST['WorkOrderName'];} else {$WorkOrderName = '';}
if (isset($_POST['CustomerName'])) {$CustomerName = $_POST['CustomerName'];} else {$CustomerName = '';}
if (isset($_POST['CustomerEmail'])) {$CustomerEmail = $_POST['CustomerEmail'];} else {$CustomerEmail = '';}
if (isset($_POST['SalesRep'])) {$SalesRep = $_POST['SalesRep'];} else {$SalesRep = '';}
if (isset($_POST['SalesRepEmail'])) {$SalesRepEmail = $_POST['SalesRepEmail'];} else {$SalesRepEmail = '';}

if (isset($_POST['SortBy'])) {$SortBy = $_POST['SortBy'];} else {$SortBy = 'WorkOrderID DESC';}
if (isset($_POST['Page'])) {$Page = $_POST['Page'];} else {$Page = 1;}

$PerPage = 30;
$StartPage = ($Page - 1) * $PerPage;
$OrderID = '';


    // All Orders
    $sql = "SELECT WorkOrderID FROM workorders WHERE WorkOrderID <>'' ";
    if (!empty($WorkOrderName)) {
        $sql .= "AND Advertiser LIKE '%". $WorkOrderName ."%' ";
    }
    if (!empty($WorkOrderID)) {
        $sql .= "AND WorkOrderID LIKE '%". $WorkOrderID ."%' ";
    }
    $result = mysql_query ($sql);
    while ($row = mysql_fetch_object ($result)) {
        $OrderID = $OrderID .", ". $row->WorkOrderID;
    }



    // Work Orders
    if (!empty($CustomerName) || !empty($CustomerEmail) || !empty($SalesRep) || !empty($SalesRepEmail)) {
        $sql = "SELECT WorkOrderID FROM workorderform WHERE WorkOrderID<>'' ";
        if (!empty($CustomerName)) {
            $sql .= "AND Advertiser LIKE '%". $CustomerName ."%' ";
        }
        if (!empty($CustomerEmail)) {
            $sql .= "AND AdContactEmail LIKE '%". $CustomerEmail ."%' ";
        }
        if (!empty($SalesRep)) {
            $sql .= "AND Salesperson LIKE '%". $SalesRep ."%' ";
        }
        if (!empty($SalesRepEmail)) {
            $sql .= "AND SalespersonEmail LIKE '%". $SalesRepEmail ."%' ";
        }
        $result = mysql_query ($sql);
        while ($row = mysql_fetch_object ($result)) {
            $OrderID = $OrderID .", ". $row->WorkOrderID;
        }
    }

    // Homescape Builder Profile
    if (!empty($CustomerName) || !empty($CustomerEmail) || !empty($SalesRep) || !empty($SalesRepEmail)) {
        $sql = "SELECT WorkOrderID FROM hs_builder_profile WHERE WorkOrderID<>'' ";
        if (!empty($CustomerName)) {
            $sql .= "AND OrganizationName LIKE '%". $CustomerName ."%' ";
        }
        if (!empty($CustomerEmail)) {
            $sql .= "AND LeadEmail LIKE '%". $CustomerEmail ."%' ";
        }
        if (!empty($SalesRep)) {
            $sql .= "AND Salesperson LIKE '%". $SalesRep ."%' ";
        }
        if (!empty($SalesRepEmail)) {
            $sql .= "AND SalespersonEmail LIKE '%". $SalesRepEmail ."%' ";
        }
        $result = mysql_query ($sql);
        while ($row = mysql_fetch_object ($result)) {
            $OrderID = $OrderID .", ". $row->WorkOrderID;
        }
    }
    
    // Homescape Builder Spec Home
    if (!empty($CustomerName) || !empty($SalesRep) || !empty($SalesRepEmail)) {
        $sql = "SELECT WorkOrderID FROM hs_spec_home WHERE WorkOrderID<>'' ";
        if (!empty($CustomerName)) {
            $sql .= "AND CommunityName LIKE '%". $CustomerName ."%' ";
        }
        if (!empty($SalesRep)) {
            $sql .= "AND Salesperson LIKE '%". $SalesRep ."%' ";
        }
        if (!empty($SalesRepEmail)) {
            $sql .= "AND SalespersonEmail LIKE '%". $SalesRepEmail ."%' ";
        }
        $result = mysql_query ($sql);
        while ($row = mysql_fetch_object ($result)) {
            $OrderID = $OrderID .", ". $row->WorkOrderID;
        }
    }

    // Planet Discover Coupon
    if (!empty($CustomerName) || !empty($SalesRep) || !empty($SalesRepEmail)) {
        $sql = "SELECT WorkOrderID FROM pd_coupon WHERE WorkOrderID<>'' ";
        if (!empty($CustomerName)) {
            $sql .= "AND BusinessName LIKE '%". $CustomerName ."%' ";
        }
        if (!empty($SalesRep)) {
            $sql .= "AND Salesperson LIKE '%". $SalesRep ."%' ";
        }
        if (!empty($SalesRepEmail)) {
            $sql .= "AND SalespersonEmail LIKE '%". $SalesRepEmail ."%' ";
        }
        $result = mysql_query ($sql);
        while ($row = mysql_fetch_object ($result)) {
            $OrderID = $OrderID .", ". $row->WorkOrderID;
        }
    }
    
    // Planet Discover Enhanced Listing
    if (!empty($CustomerName) || !empty($CustomerEmail) || !empty($SalesRep) || !empty($SalesRepEmail)) {
        $sql = "SELECT WorkOrderID FROM pd_enhanced WHERE WorkOrderID<>'' ";
        if (!empty($CustomerName)) {
            $sql .= "AND BusinessName LIKE '%". $CustomerName ."%' ";
        }
        if (!empty($CustomerEmail)) {
            $sql .= "AND Email LIKE '%". $CustomerEmail ."%' ";
        }
        if (!empty($SalesRep)) {
            $sql .= "AND Salesperson LIKE '%". $SalesRep ."%' ";
        }
        if (!empty($SalesRepEmail)) {
            $sql .= "AND SalespersonEmail LIKE '%". $SalesRepEmail ."%' ";
        }
        $result = mysql_query ($sql);
        while ($row = mysql_fetch_object ($result)) {
            $OrderID = $OrderID .", ". $row->WorkOrderID;
        }
    }
    
    // Planet Discover Right Side Text Ad
    if (!empty($CustomerName) || !empty($SalesRep) || !empty($SalesRepEmail)) {
        $sql = "SELECT WorkOrderID FROM pd_textad WHERE WorkOrderID<>'' ";
        if (!empty($CustomerName)) {
            $sql .= "AND Customer LIKE '%". $CustomerName ."%' ";
        }
        if (!empty($SalesRep)) {
            $sql .= "AND Salesperson LIKE '%". $SalesRep ."%' ";
        }
        if (!empty($SalesRepEmail)) {
            $sql .= "AND SalespersonEmail LIKE '%". $SalesRepEmail ."%' ";
        }
        $result = mysql_query ($sql);
        while ($row = mysql_fetch_object ($result)) {
            $OrderID = $OrderID .", ". $row->WorkOrderID;
        }
    }

    if (substr($OrderID, -2) == ", ") {
        $OrderID = substr($OrderID, 0, -2);
    }
    
    if (substr($OrderID, 0, 2) == ", ") {
        $OrderID = substr($OrderID, 2);
    }


    $sql = "SELECT WorkOrderID FROM workorders WHERE WorkOrderID IN ($OrderID)";
    $result = mysql_query ($sql);
    $Total = ceil(mysql_num_rows($result)/$PerPage); <-error happens here

    $sql = "SELECT WorkOrderID, DATE_FORMAT(CreatedDate,'%m/%e/%y') AS SubmitDate, Location, AdminID, FormName, Status FROM ";
    $sql .= "workorders WHERE WorkOrderID IN ($OrderID) ORDER BY $SortBy LIMIT $StartPage, $PerPage";
    $result = mysql_query ($sql);
    
    
If ($Page > 0) {$PagePrev = ($Page - 1);} else {$PagePrev = '';}
If ($Page < $Total) {$PageNext = ($Page + 1);} else {$PageNext = '';}
?>

 

Thanks in advance to any help!

T.

[Jabop]

Why do people just post code and say there's an error fix it...

 

What is "the mysql_num_rows error?"

[Goldeneye]

Which line is giving this error? And what exactly is the error?