fritz Jung
07-24-2002, 01:58 PM
Seems like I am wasting processing power with this...
$sql="UPDATE traffic SET hits=hits+1 Where (record_no='0001')";
$sql="UPDATE traffic SET hits_mtd=hits_mtd+1 Where (record_no='0001')";
Am having trouble nesting this.... I've tried
$sql="UPDATE traffic SET hits=hits+1, SET hits_mtd=hits_mtd+1 Where (record_no='0001')";
and
$sql="UPDATE traffic SET hits=hits+1, hits_mtd=hits_mtd+1 Where (record_no='0001')";
But those have no effect ...
How can I nest a bunch of SET statements in a single SQL call?
$sql="UPDATE traffic SET hits=hits+1 Where (record_no='0001')";
$sql="UPDATE traffic SET hits_mtd=hits_mtd+1 Where (record_no='0001')";
Am having trouble nesting this.... I've tried
$sql="UPDATE traffic SET hits=hits+1, SET hits_mtd=hits_mtd+1 Where (record_no='0001')";
and
$sql="UPDATE traffic SET hits=hits+1, hits_mtd=hits_mtd+1 Where (record_no='0001')";
But those have no effect ...
How can I nest a bunch of SET statements in a single SQL call?