Hey Everyone, been steaming right along for a couple days but now I'm stuck
on writing a search function, could you all take a look at it and see what
it could be, I will mark the line throwing the error in red, I did try just
commenting out that line and searching for a record by OrderID that I know
is there but it does not return anything , I am trying to search several
tables in one db:
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);
*
$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 = '';}
?>
the error is this one: *Warning*: mysql_num_rows(): supplied argument is not
a valid MySQL result resource in *
C:\Inetpub\Xampp\htdocs\SNLeader\WOSystemN\ViewOrders.php* on line *182
Thanks in advance
*
