Multiple query's at a time?

[unknowngiver]

Hey
This is probably my last day of bugging for help :p cuz this game is due 2marrow

anyway i was wondering if i can run2 querys at the same time ? or something similar

here is what i want:

i am going to calculate all the stuff in turing and send who won with the new "Health" and "Money"
and i want to update both of the users fields ....for health and money...

how would i do that?
and also 2 update...is there a special command or do i just use the same method that i use 2 add something new....??

thanks :D

P.s: if you would like to beta test my turing game add me on msn [also if ur gud at php ..so i dont have to post it here:p] my msn is [email protected]

 

[Dan]

This is for if health and money are strings. If they aren't remove the quotes around $health and $money.

UPDATE table SET health = '$health', money = '$money' WHERE username = '$username'

Also, I don't know the table name or what the field username is called. If you don't have username you can use whatever.. but if you don't have a WHERE it will change everyone's health and money.