fetchAll(PDO::FETCH_ASSOC);
$haswatch = count($rows);
$repeatchecked = 0;
foreach ($rows as $row) {
if ($row['repeatwatch'] == 1) {
$repeatchecked = 1;
}
}
if ($haswatch > 0) {
$u = "UPDATE viamedquoteorderwatch SET status = 'Stopped' WHERE company_id = ? AND status = 'On' AND ordertype = ?";
pdoquery($u, array($companyid, $ordertype));
} else {
$i = "INSERT INTO viamedquoteorderwatch (userid, status, addedby, addedon, company_id, repeatwatch, ordertype) VALUES (?, 'On', ?, ?, ?, ?, ?)";
pdoquery($i, array($vui, $localname, $nowis, $companyid, $repeatwatch, $ordertype));
}
$s = "SELECT * FROM viamedquoteorderwatch WHERE userid = ? AND company_id = ? AND status = 'On' AND ordertype = ?";
$stmt = pdoquery($s, array($vui, $companyid, $ordertype));
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
$haswatch = count($rows);
$repeatchecked = " Only Next Order";
foreach ($rows as $row) {
if ($row['repeatwatch'] == 1) {
$repeatchecked = " All Orders";
}
}
if ($haswatch > 0) {
print "$repeatchecked";
} else {
print " With Repeat Orders";
}
?>