multiple SET calls

Anon

Seems like I am wasting processing power with this...

$sql="UPDATE traffic SET hits=hits+1 Where (record_no='0001')"; $results =
mysql_query($sql);
$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?

Fritz

Anon

$newhits = $hits++;
$newhits_mtd = $hits_mtd++;
$sql="UPDATE traffic SET hits='$newhits', hits_mtd='$newhits_mtd' WHERE record_no='0001'";

Ok first you need to pull out of the database hits and hits_mtd... Then add one to each... Then you can use them in the Update statement. MySQL cannot add 1 to anything in your database. Well atleast I know of. I have been wrong though many times. So call the current values out and then add one and then update the table where record_no equals 0001... I didn't think you could have (record_no='0001') So just take it out. Then everything should be smooth sailing. I use this technique in my counter on my main page and just put all of it in a .inc. Mine though takes their IP logs it, and then if they come on the main page again it will search through it and see if it has already been used and if so then it just ignores that count. Its kinda cool but I took it down because it got WAYYY too big and plus for the DHCP kids it changes all the time and also the Gayolers. So thats just a "real world" application of it.

Chad R. Smith
www.brokenformula.com

Anon

Thanks for the thoughts...

But I am already using the Set field=field+1 quite effectively..

http://www.witchvox.com/xwrensnest.html

My question is in an update statement... How can I do multiple

Set field=field+1 Set field2=field2+1 etc
to 'tickle' the counters for those records...

Comma separation doesn't work, a space doesn't work...

Help????