Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Pre-filled stock count import template [solved]
02-27-2022, 01:45 PM,
#7
RE: Pre-filled stock count import template
(02-27-2022, 01:32 AM)TimSchofield Wrote: Changing that whole sql statement to be:

$sql = "SELECT locstock.stockid, stockmaster.description, SUM(quantity) FROM locstock INNER JOIN stockmaster ON locstock.stockid=stockmaster.stockid
INNER JOIN locationusers ON locationusers.loccode=locstock.loccode AND locationusers.userid='" .  $_SESSION['UserID'] . "' AND locationusers.canview=1
GROUP BY stockid";

should qwork, but I have only done very basic checking on it, so make sure what you get looks right

Tim
Will work from these info.   Thank you very much!  
Reply


Messages In This Thread
RE: Pre-filled stock count import template - by wackyduckie - 02-27-2022, 01:45 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)