Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 5406 | Replies: 4
•
•
Join Date: Mar 2004
Location: In a house
Posts: 94
Reputation: 
Rep Power: 5
Solved Threads: 0
Junior Poster in Training
I have been looking into ways I to cut down on MySQL Querys in a page and I was wandering if you could up to update querys into one mysql_query function like this:
[php]mysql_query("UPDATE table SET val1=val1+1, val2=val2+1 WHERE id = (int); UPDATE table SET val3=val3+1, val4=val4+1 WHERE id = (int)") or die(mysql_query());[/php]
*Note: both the (int) values are different.
[php]mysql_query("UPDATE table SET val1=val1+1, val2=val2+1 WHERE id = (int); UPDATE table SET val3=val3+1, val4=val4+1 WHERE id = (int)") or die(mysql_query());[/php]
*Note: both the (int) values are different.
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Threaded Mode