MySQL Logging Help!

Hi, I have a table called actions within it is giver, reciever, action, I also have another table called user, with user and points in it.

What I do is have a script that lets x user give x amount of gil to x user2. Now I just want to be sure, but would you use the

"UPDATE action SET giver='$giver', reciever='$reciever', action='$action'"

to update the table. but how would I go about getting it to make a new row with the information? could I do it like this

"UPDATE action SET giver='$giver', reciever='$reciever', action='$action' WHERE actionid='$actionid+1'"

i am not to sure, thanks for the help in advanced.

or would i use a INSERT to do it?

You would use an insert statment for your query.

something like "insert in to action (giver, receiver, action) values ($giver, $receiver, $action);"

Or something similiar.

Have Fun.

Dan