ChockersLists_Sites($intSiteID); $intSiteDetailsRealTotal = SQLFoundRows(); if ($intSiteDetailsRealTotal>0) { $strSiteAddress1 = $arrSiteDetails[0]['s_address1']; $strSiteAddress2 = $arrSiteDetails[0]['s_address2']; $strSiteAddress3 = $arrSiteDetails[0]['s_address3']; $strSiteAddressTown = $arrSiteDetails[0]['s_town']; $strSiteAddressCounty = $arrSiteDetails[0]['s_county']; $strSiteAddressPostCode = $arrSiteDetails[0]['s_postcode']; $strSiteTelephone = $arrSiteDetails[0]['s_telephone']; $strSiteTelephone2 = $arrSiteDetails[0]['s_telephone2']; $strSiteFax = $arrSiteDetails[0]['s_fax']; $strSiteMessage = $arrSiteDetails[0]['s_message']; $strSiteCurrentStyle = $arrSiteDetails[0]['s_currentstyle']; $strSitePassword = $arrSiteDetails[0]['s_password']; $strSitePasswordAdmin = $arrSiteDetails[0]['s_password_admin']; } ?> Chockers Shoes - POS

Deposits - Sales In Progress

[↓↑] Move up or down to select the required sale
[Enter] Process selected order

Ref Order Date Last Updated
SELECT SQL_CALC_FOUND_ROWS * FROM sales sa LEFT JOIN salesitems sai ON sai.sai_sa_id=sa.sa_id WHERE sa.sa_s_id = 2 AND sa.sa_active = 1 AND sa.sa_completed = 0 AND sa.sa_inprogress = 1 GROUP BY sa_id ORDER BY sa_dateadded ASC

Table 'chockerspos_db.sales' doesn't exist